Practical Power BI. Real Business Impact.

09 Sept 2022

Implicit vs Explicit Measures in Power BI

A clear explanation of the difference between implicit and explicit measures in Power BI, and why explicit measures are recommended for better model control.

Read More →

02 Sept 2022

Using Variables in DAX (Power BI Guide)

A practical guide to using variables in DAX to improve readability, performance, and maintainability of Power BI calculations.

Read More →

26 Aug 2022

ALL vs ALLSELECTED vs ALLEXCEPT in DAX (Power BI Guide)

A clear explanation of the differences between ALL, ALLSELECTED, and ALLEXCEPT in DAX, including how they affect filter context in Power BI.

Read More →

22 Aug 2022

FILTER vs KEEPFILTERS in DAX (Power BI Guide)

A practical comparison of FILTER and KEEPFILTERS in DAX, explaining how each function affects filter context and when to use them in Power BI.

Read More →

27 Feb 2022

Calculated Columns vs Measures in Power BI

A clear explanation of the difference between calculated columns and measures in Power BI, including when to use each and how they impact performance.

Read More →

20 Feb 2022

RELATED vs LOOKUPVALUE in Power BI: What’s the Difference?

A practical comparison of RELATED and LOOKUPVALUE in Power BI, explaining how each function works and when to use them in DAX calculations.

Read More →

13 Feb 2022

Append vs Merge in Power BI: What’s the Difference?

A clear explanation of the difference between Append and Merge in Power BI, including when to use each in Power Query transformations.

Read More →

06 Feb 2022

Reference vs Duplicate in Power BI: What’s the Difference?

A practical explanation of the difference between Reference and Duplicate in Power BI Power Query, including when to use each approach.

Read More →

02 Jun 2021

7 Commonly Used DAX Expressions in Power BI

A practical overview of seven commonly used DAX expressions in Power BI and how they are applied in real-world reporting scenarios.

Read More →