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
Calculations reporting values at the start or the end of a time period are quite the challenge for any BI developer and DAX is no exception These measures are not hard to compute the complicated part is understanding the desired… 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