DAX Prism

About DAX Prism

Hi, I’m David.

I spent several years working with Power BI at a Fortune 100 company, moving from business analyst to data analyst to analytics engineer. Most of that time wasn’t spent building new things. It was spent maintaining old ones. Reports I inherited had years of band-aids stacked on top of each other: measures referencing measures referencing measures, columns no one could explain, logic that broke the moment you touched the wrong thing.

Every change started the same way. Hours of archaeology just to understand what I was looking at before I could safely alter a single line. There was no map, so I built one.

What it does

DAX Prism reads a Power BI template (.pbit) and hands back the thing the original author never wrote: clear documentation. Drop in a file and you get plain-English descriptions of every measure, a dependency map that traces each calculation to the columns and measures beneath it, and a shortlist of fields nothing references anymore — the dead weight you can safely cut. Files are processed in memory and never stored.

DAX Prism is the tool I wished I’d had on day one of every handoff, the one that turns “whose mess is this and where do I even start” into something you can actually read. If you’ve inherited a report you’re afraid to touch, or you’re putting off knowledge transfer to a coworker, this is for you.

— David