January 16, 2014 was the day we at SQLBI sent out our first newsletter. We had less than 8,000 subscribers back then. We went on to send newsletters out every other week for more than seven years, always trying to…  Read more

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

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

The new video course to create enterprise-level solutions with Power BI and Analysis Services is available!  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

This article provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and the Date dimension.  Read more

This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet retain the full capability to select different values.  Read more

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it.  Read more

This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition.  Read more

In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months.  Read more