DAX

Budget vs. Actual Model in Power BI: Calculations and DAX

In the previous article, I explained how you can build a data model for budget vs. actual, where the grain of the two fact tables is different. The model works perfectly as a star schema. As long as you slice and dice data in the level of granularity that both tables...

read more

Importing Performance Analyzer data in DAX Studio

The Power BI Performance Analyzer is a feature that simplifies the collection of DAX queries generated by Power BI. We already described it in the Introducing the Power BI Performance Analyzer article. The version 2.9.0 of DAX Studio introduced a new feature to import...

read more

Mastering DAX video course, 2nd edition

It is with great joy that we want to share some awesome news with you!The production of SQLBI's second edition of the Mastering DAX video course is now complete! The first edition of the Mastering DAX video course was recorded three years ago. It was our first course...

read more

Mastering DAX video course, 2nd edition

It is with great joy that we want to share some awesome news with you!The production of SQLBI's second edition of the Mastering DAX video course is now complete! The first edition of the Mastering DAX video course was recorded three years ago. It was our first course...

read more

Creating a simple date table in DAX

A date table is required for most time intelligence calculations such as year-to-date, previous year or moving averages. If a data model does not already have a date table, it is possible to create one using a calculated table and some basic DAX code. The date table...

read more

Table and column references using DAX variables

Using variables in DAX makes the code much easier to write and read. You can split a complex operation into smaller steps by storing a number, a string, or a table into a variable. When you store a scalar value in a variable, the behavior is intuitive and common to...

read more

Creating a simple date table in DAX

A date table is required for most time intelligence calculations such as year-to-date, previous year or moving averages. If a data model does not already have a date table, it is possible to create one using a calculated table and some basic DAX code. The date table...

read more

Table and column references using DAX variables

Using variables in DAX makes the code much easier to write and read. You can split a complex operation into smaller steps by storing a number, a string, or a table into a variable. When you store a scalar value in a variable, the behavior is intuitive and common to...

read more
Share This