Latest from the blog.
Deep-dives on DAX, filter context, and the skill Copilot can’t fake — from the team building the rig.
How to Master DAX: A 30-Day Practice Plan
Master DAX with a practical 30-day plan built around filter context, deliberate exercises, debugging, and daily feedback—not tutorials or…
DAX: Ignore One Slicer but Keep Every Other Filter
Make one DAX measure ignore a single slicer while preserving date, customer, region, and every other report filter with narrowly scoped…
SAMEPERIODLASTYEAR Returns Blank? 8 Checks for Power BI
When SAMEPERIODLASTYEAR returns blank, verify the prior-year dates, date table, active relationship, visual field, data coverage, and date…
DAX Studio vs DAX.do vs DAX Solver: Which Tool to Use?
DAX Studio is strongest for model diagnostics, DAX.do for quick browser experiments, and DAX Solver for structured practice with graded…
BLANK vs 0 in DAX: How to Control Empty Results
BLANK usually means no meaningful result, while 0 is a real numeric result. Learn how DIVIDE, COALESCE, relationships, and visuals affect empty…
DAX Measure Returns BLANK? A Diagnostic Flow for Power BI
When a DAX measure returns BLANK, trace the base rows, filter context, relationships, scalar assumptions, date coverage, division, and display…
Power BI Running Total Is Wrong? 7 DAX Fixes
Fix a wrong Power BI running total by checking the date table, axis, relationship, filter-removal scope, slicer boundary, grain, and missing…
DAX Measure vs Calculated Column: When to Use Each
Use a DAX measure for dynamic results that respond to filters. Use a calculated column for stored row-level attributes used on axes, slicers…
ALL vs ALLSELECTED vs ALLEXCEPT in DAX
ALL clears specified filters, ALLSELECTED supports visual totals, and ALLEXCEPT clears a table except named columns. Compare them with…
Stop reading. Start writing.
The best way to understand CALCULATE is to miss a test case. Pick a challenge and go.