08 Oct 2022
Understanding SUMMARIZE in DAX (Power BI Guide)
A practical guide to understanding the SUMMARIZE function in DAX, how it works, and when to use it in Power BI data models.
Read More →Browse by Category
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 →