article –
Naming temporary columns in DAX
This article describes a naming convention for temporary columns in DAX expressions to avoid ambiguity with the measure reference notation. Read more
article –
Strong and weak relationships in Power BI
This article describes what weak relationships are and the differences between strong and weak relationship in Power BI and DAX. Read more
Video –
Aug 5, 2019
My Power BI Report is Slow – What Should I Do?
More videos
Oct 30-Nov 1 - San Francisco
Nov 26-28 - Amsterdam
Nov 12-14 - Toronto
Video Training
Introducing DAX Video CourseFree
article –
DAX 101
Previous year up to a certain date
This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years. Read more
article –
Creating a slicer that filters multiple columns in Power BI
This article describes how to create a slicer showing the values of multiple columns, applying the filter on any of the underlying columns. 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
The Definitive Guide to DAX – 2nd Edition
The Definitive Guide to DAX (Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI) is the most comprehensive and authoritative guide to Microsoft’s DAX language for business intelligence and analytics. While other books cover only the basics, this guide offers expert guidance on everything intermediate-to-advanced Excel users and BI professionals need to know, from the basics to innovative high-performance techniques. Read more