Topic: Power BI
-
DAX provides a set of functions (Time Intelligence) to compute aggregations and comparisons over a range of dates: Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. The DAX time intelligence functions can work well with a month granularity, but they have… Watch now
-
Learn how to debug a DAX measure that returns an incorrect result by using different techniques, with and without external tools. Watch now
-
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Read more
-
If you create server aliases for SQL Server connections, you should be aware of the changes introduced in SQL Server 2022. At SQLBI we use aliases to identify the server’s name in the connection of our sample files (Power BI… Read more
-
A recap of the news in the DAX world in 2022 and a preview of what we expect in 2023. Happy New Year! Watch now
-
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
-
This video explains the more common errors in CALCULATE filter arguments and how to solve them. Watch now
-
Calculation groups are the most important feature introduced in DAX after variables in 2015. By using calculation groups, you can apply transformations to existing measures without having to create new measures in the model. For example, you can define the… Watch now
-
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
