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 Events in Progress pattern has a broad field of application It is useful whenever dealing with events with a duration - events that have a start date and an end date The event is considered to be in progress… 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