We recently updated SUMMARIZECOLUMNS on DAX Guide by adding an example that clarifies the difference between a filter applied to SUMMARIZECOLUMNS and a filter applied to CALCULATETABLE. Most of the times, you can move a filter from a SUMMARIZECOLUMNS argument… Read more
Using variables in DAX makes the code easier to read, faster, and easier to debug. In this article, we discuss how and when to use variables, along with why they are so important in any DAX expression. Read more
Rolling averages are a very common calculation used to smooth out charts. This article shows how to compute a rolling average taking into account only the working days. Read more
The Whiteboard is a new series on the SQLBI YouTube channel where I use a whiteboard to describe abstract DAX and Tabular concepts in a more interactive way. I usually represent these concepts by drawing on a whiteboard in our… Read more
The New and returning customers pattern helps in understanding how many customers in a period are new returning lost or recovered There are several variations to this pattern each with different performance and results depending on the requirements Moreover it… More on DAX Patterns
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more
Munich (München), DE
Marco Russo
Marco Russo & Alberto Ferrari
Nov 9-11 - Chicago
Dec 5-7 - Amsterdam
Sep 28-30 - Brisbane