Munich (München), DEComputing sales to specific customers before and after a time period
Marco Russo & Alberto FerrariThis article shows how to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected month. Read more
Different filter behaviors in SUMMARIZECOLUMNS and CALCULATETABLE
Marco RussoWe 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
Nov 9-11 - Chicago
Dec 5-7 - Amsterdam
Sep 28-30 - Brisbane
Video Training
Introducing DAX Video CourseFree
Variables in DAX
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 average with working days in DAX
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
DAX Patterns
Standard time-related calculations
In this pattern we show you how to compute time-related calculations like year-to-date same period last year and percentage growth using a standard calendar The great advantage of working with a standard calendar is that you can rely on several… More on DAX Patterns
SQLBI Corp.
DAX Patterns, Second Edition
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