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.
Data Modeling
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.
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.
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.
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.
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.
10 Mar 2023
Introduction to Calculation Groups in Power BI
An introduction to calculation groups in Power BI, how they work, and how they simplify time intelligence and reusable DAX logic.
07 Jul 2023
How to Use USERELATIONSHIP in DAX (Power BI Guide)
A practical explanation of how USERELATIONSHIP works in DAX, when to use it, and how to handle multiple relationships in Power BI.
12 Apr 2024
How to Handle High Cardinality Columns in Power BI
A practical explanation of high cardinality columns in Power BI, why they affect performance, and strategies to optimize your data model.
27 Jul 2024
How to Identify and Delete Unused Columns and Measures in Power BI
A practical guide to identifying and safely removing unused columns and measures in Power BI to improve model performance and maintainability.
23 Aug 2025
Best Practice Analyzer (BPA) Guide for Power BI
A practical guide to using Best Practice Analyzer (BPA) in Power BI to improve model quality, enforce standards, and maintain clean semantic models.
24 Sept 2025
Beginner’s Guide to Tabular Editor
A beginner-friendly guide to understanding and using Tabular Editor for managing measures, improving model structure, and applying best practices in Power BI.