The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best.  Read more

This article explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool.  Read more

The filter arguments in CALCULATE can be written as logical conditions with certain restrictions. This article explains the more common errors in these conditions and how to solve them.  Read more

SQLBI+ is our new subscription service for advanced content that supports professional model authors who create semantic models for Power BI and Analysis Services.  Read more

Understanding the difference between row context and filter context is the first and most important concept to learn to use DAX correctly. This article introduces the row context, and is part of a series of articles about evaluation contexts in…  Read more

The first version of Bravo for Power BI is now generally available!  Read more

Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this article, we introduce this optimization with some examples.  Read more

A common question is why Power BI totals are inaccurate because they do not display the sum of individual rows. In this article, we explain the reasons why those totals are correct.  Read more

This article describes how to enable the cross-highlight in Power BI charts using different dates for the same event, such as Order Date and Delivery Date.  Read more

RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. In this article we introduce the RANKX function with a few…  Read more