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.
Best Practices
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.
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.
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.
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.
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.
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.
18 Nov 2022
Dynamic Titles in Power BI
A practical guide to creating dynamic titles in Power BI using DAX to make reports more interactive and context-aware.
02 Dec 2022
Tips and Tricks for Data Labels in Power BI
Practical tips and tricks for formatting and customizing data labels in Power BI to improve readability and visual clarity.
10 Feb 2023
Introduction to Field Parameters in Power BI
An introduction to field parameters in Power BI, how they work, and how they enable dynamic switching of dimensions and measures in reports.
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.
24 Mar 2023
Why Totals Look Wrong in Power BI (And How to Fix Them)
An explanation of why totals sometimes appear incorrect in Power BI and practical techniques to fix common DAX and context-related issues.
21 Apr 2023
Introduction to the Slicer Panel in Power BI
An introduction to the slicer panel in Power BI, including how it works, when to use it, and how it improves report usability.
28 Apr 2023
Rolling Totals vs Running Totals in Power BI: What’s the Difference?
A clear explanation of the difference between rolling totals and running totals in Power BI, including practical examples and common use cases.
16 Jun 2023
Power BI Bookmarks: Beginner’s Guide
A beginner-friendly guide to understanding and using bookmarks in Power BI to create dynamic and interactive reports.
23 Jun 2023
Do We Really Need KEEPFILTERS in DAX?
An explanation of how KEEPFILTERS works in DAX, when it is necessary, and how it affects filter context in Power BI calculations.
30 Jun 2023
New KPI Card Visual in Power BI: Features and Use Cases
An overview of the new KPI Card visual in Power BI, including its features, improvements, and practical use cases for building better dashboards.
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.
09 Feb 2024
Ultimate Beginner’s Guide to DAX Studio
A complete beginner-friendly guide to using DAX Studio for analyzing queries, improving performance, and understanding your Power BI data model.
16 Feb 2024
PBIX vs PBIT: Understanding the Difference in Power BI
A clear explanation of the difference between PBIX and PBIT files in Power BI, when to use each format, and how they impact collaboration and deployment.
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.
19 Apr 2024
Optimizing Measures with DAX Studio in Power BI
A practical guide to using DAX Studio to analyze and optimize measures in Power BI for better performance and cleaner model design.
17 May 2024
How to Handle Blanks Effectively in Power BI
A practical guide to understanding and handling blank values in Power BI, including common pitfalls and techniques to avoid incorrect calculations.
31 May 2024
Highlighting Top N Results Using RANKX and TOPN in Power BI
A practical guide to using RANKX and TOPN in Power BI to dynamically highlight top N values and build more insightful reports.
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.
31 Aug 2024
Everything You Need to Know About Paginated Reports in Power BI
A complete guide to Paginated Reports in Power BI, including when to use them, how they differ from interactive reports, and best practices for implementation.
08 Feb 2025
Introduction to TMDL in Power BI
An introduction to TMDL (Tabular Model Definition Language) in Power BI, what it is, why it matters, and how it changes model development workflows.
15 Feb 2025
How to Copy Bookmarks from One Power BI Report to Another
A step-by-step explanation of how to copy bookmarks between Power BI reports and avoid common issues when reusing report interactions.
29 Mar 2025
Why Every Power BI Report Needs a Proper Description
Why adding clear descriptions to measures, reports, and datasets in Power BI improves usability, governance, and long-term maintainability.
19 Apr 2025
Playing with Totals in Power BI
A practical guide to understanding and controlling totals in Power BI, including common mistakes and techniques to get accurate results.
31 May 2025
Page Level Security vs Object Level Security in Power BI
A clear explanation of Page Level Security and Object Level Security in Power BI, how they differ, and when to use each approach.
14 Jun 2025
Introduction to Power Ops
An introduction to Power Ops, what it means in the Power BI ecosystem, and why operational discipline is becoming essential for modern BI teams.
12 Jul 2025
Going Beyond with Field Parameters in Power BI
How to take Field Parameters beyond the basics in Power BI and use them effectively for dynamic reporting and better user interaction.
09 Aug 2025
Common Pitfalls with VALUES, DISTINCT, and VALUE in Power BI
A practical explanation of common mistakes developers make when using VALUES, DISTINCT, and VALUE in Power BI, and how to avoid unexpected results.
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.
22 Nov 2025
Power BI: Checklist I run before publishing any report
A practical checklist I follow before publishing any Power BI report to ensure clarity, performance, and stakeholder value.
06 Dec 2025
From One Big PBIX to a Shared Dataset + Thin Reports
How to move from a single heavy PBIX file to a shared dataset architecture in Power BI.
30 Dec 2025
Understanding Fabric Capacity Spikes: What’s Really Causing Them
A practical breakdown of why Fabric capacity spikes happen, what typically causes them, and how to diagnose and prevent unexpected performance issues.
18 Jan 2026
How to Automate Power BI Documentation
A practical guide to automating Power BI documentation using tools and best practices to improve governance, transparency, and maintainability.
09 Mar 2026
Exporting Data from Power BI to Excel: Options, Limitations, and Better Alternatives
Learn how exporting data from Power BI to Excel works, the limitations to consider, its impact on capacity, and better alternatives such as paginated reports and automated extracts.
22 Mar 2026
When Power BI Gets Messy: What Governance Actually Looks Like
A practical look at what happens when a Power BI setup gets messy and how governance helps bring structure, reduce confusion, and improve trust.
04 Apr 2026
How to Start with Power Automate in Power BI (What Actually Matters)
Learn how to use Power Automate in Power BI beyond basic alerts. Practical use cases to manage datasets, improve data trust, and keep your BI environment under control.