Launch Offer - 20% OFF on SSAS Tabular Video Course

DAX Patterns

ARTICLE

Analyzing events with a duration in DAX

This article analyzes how to efficiently work with events that lasts over time, such as the duration of an order considering the distance between order date and ship date.

ARTICLE

Computing New Customers in DAX

In this article, Alberto Ferrari describes a new efficient way to compute returning customers in DAX thanks to an idea suggested by a student attending an Optimizing DAX workshop.

VIDEO

Budgeting with PowerPivot

Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources. In order to use these new features, you will continue to leverage existing skillsets, such as Tabular,

VIDEO

Many-to-Many Relationships in DAX

VIDEO

DAX Patterns

The DAX language has a low number of built-in functions, but it is very flexible and you can write complex calculations with it. It is so flexible that you might find many alternative ways to write an expression solving a business problem. You can save development time by adapting an

VIDEO

DAX Patterns: Banding, New vs Old, Many-to-many

Alberto Ferrari shows how to solve common business patterns using the DAX language in this 50-minute, demo-focused video. Patterns are useful for two reasons: they let you learn advanced DAX techniques and, by adapting their code to your needs, you can use them as a quick recipe for your own

VIDEO

DAX Time Intelligence

Alberto begins this video with a brief introduction to Time Intelligence, before showing you how to create a calendar table, which is needed for any time intelligence function to work. It can be created using Excel, or by loading it from a data warehouse, or from another database, if available.