Build a star schema from a single flat file
One wide CSV, thousands of repeated names. By the end you have a fact table, two dimension tables, and a model Power BI actually wants.
Latest from the terminal
All posts →-
-
VAR: the DAX keyword that makes your measures readable
A DAX measure that repeats the same subtotal three times isn't thorough, it's a maintenance problem VAR was built to fix.
-
A week of actually using Copilot: what a beginner discovers (and what trips them up)
Seven days actually driving Copilot across Excel, Word and PowerPoint - the wins, the confidently wrong deck, and the habit that mattered more than any prompt.
-
Format painter: copy a Power BI visual's formatting in one click
Power BI's format painter copies fonts, colours and borders across visuals in one click, except for one axis setting that quietly breaks chart comparisons.
-
Saying no without sounding like you can't do it
The ask is legitimate, the person is reasonable, and the honest answer is no - here's how to say it without it sounding like you can't cope.
-
Power Query from Scratch, Part 4: Custom columns and your first look at M
Three parts of buttons, then a request that needs an 'and' the Conditional Column dialog doesn't have - time to type your first line of M.