article –
DAX 101
Counting working days in DAX
This article shows a DAX technique to compute the number of working days between two dates. Read more
article –
DAX 101
Computing running totals in DAX
This article shows how to compute a running total over a dimension, like for example the date. Read more
Video –
Mar 18, 2019
Different types of many-to-many relationships in Power BI
More videos
Mar 25-27 - Chicago
May 8-10 - Amsterdam
Jun 3-5 - Calgary
Jul 23-25 - Melbourne
May 21-23 - Helsinki
Video Training
Introducing DAX Video CourseFree
article –
Displaying filter context in Power BI Tooltips
This article describes how to display the filter context applied to a calculation using a special DAX measure in Power BI Tooltips. Read more
article –
Hiding future dates for calculations in DAX
This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. 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