When you use a measure as a filter in a Power BI visual, the DAX code generated might display different behaviors depending on whether the measure is part of the values shown in the visual or not. In this article,… Read more
The new video course to create enterprise-level solutions with Power BI and Analysis Services is available! Read more
ALLEXCEPT is a handy DAX function to retrieve all the columns of a table except for some. When used as a CALCULATE modifier, its behavior is less intuitive and might result in inaccurate measures. In this article, we elaborate on… Read more
This article explains how the CONTAINS function works and what can be used as better alternatives in DAX in common use cases. Read more
The cumulative total pattern allows you to perform calculations such as running totals You can use it to implement warehouse stock and balance sheet calculations using the original transactions instead of using snapshots of data over time For example in… 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
Copenhagen, DK
Marco Russo & Alberto Ferrari
Mar 15-17 - New York City
May 11-13 - Sydney
Sep 30-Oct 2 - Amsterdam