Topic: Power Pivot

       58 articles of 243 posts
article –

Semi-Additive Measures in DAX

Values such as inventory and account balance, usually calculated from a snapshot table, require the use of semi-additive measures. This article describes how to implement these calculations in DAX according to your specific requirements.  Read more

article –

Understanding numeric data type conversions in DAX

This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages.  Read more

article –

Context Transition and Filters in CALCULATE

This article explains how the context transition interacts with the filter arguments of a CALCULATE function in DAX. This is important in order to avoid unexpected results with complex calculations made in filter arguments.  Read more

article –

How to handle BLANK in DAX measures

This article describes a counterintuitive behavior of BLANK in DAX measures affecting Power BI, Analysis Services, and Power Pivot. That behavior could cause mistakes in a report using alternate expressions of the same calculation. Indeed, these expressions are not equivalent…  Read more

article –

Using KEEPFILTERS in DAX

This article explains how to use KEEPFILTERS to intersect instead of overriding an existing filter context in DAX, simplifying the code and improving performance.  Read more

article –

Start learning DAX for free

SQLBI offers a new introductory DAX video course called Introducing DAX. This article describes which users will benefit more from this learning experience, and how to enroll in the course.  Read more