Topic: Power BI
-
This article describes the possible rounding differences that can appear in DAX. They are related to the data types and the operation being performed: knowing these details helps you write more robust DAX formulas and avoid errors in comparisons. Read more
-
Optimize the query performance of a SWITCH function in DAX that reads a slicer selection: the Group By Columns property can solve a practical problem. Watch now
-
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 describes how to implement a DAX measure to run faster than what you get from the built-in fusion optimization. Read more
-
How to implement a DAX measure to run faster than what you get from the built-in horizontal fusion optimization. Watch now
-
DAX Studio 3.0.6 introduces a new Timeline visualization in Server Timings to help you investigate performance issues: let’s explore how it works! Watch now
-
This article describes how Power BI uses the Group By Columns attribute of a column and how you can leverage it in specific scenarios. Read more
-
How can we show a row with the initial balance in a Power BI report? Another video that answers a student’s question! Watch now
-
Every Power BI model has dates and the need for calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and standard time intelligence functions in DAX can help, but how do… Watch now
-
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