article –
Understanding DAX Auto-Exist
This article describes the behavior of auto-exist in DAX, explaining the side effects of combining slicers on columns of the same table in Power BI. Read more
blog post –
DAX Guide – the reference I had been wanting
Marco RussoIf you have read the book Alberto and I wrote, “The Definitive Guide to DAX” then by looking at the title you might think that this post is about the book. Not this time. I am talking about the new… Read more
Video –
Jul 24, 2018
Power BI DAX optimization examples
Oct 16-18 - London
Nov 28-30 - New York
Video Training
Introducing DAX Video CourseFree
article –
Optimizing nested iterators in DAX
This article describes possible optimization approaches to improve the performance of nested iterators in DAX. Read more
blog post –
DAX Studio and Power BI diagnostic port
DAX Studio connects to a Power BI Desktop model using a technique that was not officially supported until a few months ago. This changed when the “diagnostic port” was documented in this article of the official documentation: 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