article –
Mastering DAX video course, 2nd edition
The second edition of the Mastering DAX video course is available! Read more
article –
DAX 101
Automatic time intelligence in Power BI
This article shows why building custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. Read more
Video –
Apr 15, 2019
Aggregations in Power BI
More videos
Jun 3-5 - Calgary
Jul 23-25 - Melbourne
Nov 26-28 - Amsterdam
May 21-23 - Cincinnati
May 21-23 - Helsinki
Jun 18-20 - Aarhus
Video Training
Introducing DAX Video CourseFree
article –
DAX 101
Creating a simple date table in DAX
This article shows how to build a basic date table using a calculated table and DAX. Read more
article –
DAX 101
Year-to-date filtering weekdays in DAX
Time intelligence functions oftentimes hide an automatic ALL statement meant to make time intelligence calculations easier. This article describes this behavior and what to do in case it ends up breaking your calculation. Read more
DAX Patterns
ABC Classification – Dynamic
The dynamic version of the ABC Classification pattern is an extension of the Dynamic Segmentation pattern It groups items such as Products or Customers into segments based on their cumulated sales and how much they contributed to the total sales… www.sqlbi.com
Book –
Microsoft Press
Analyzing Data with Power BI and Power Pivot for Excel
How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. Read more