What is DAX in Power BI: Practical Guide + Examples
Learn DAX from scratch: what it is, what it's for, difference from Power Query, the 5 essential functions, and common mistakes. With code examples.
Posts about dax
Debugging in Power BI: The Complete Guide
Step by step when the numbers don't match. From the 80% rule to database validation.
Power BI Deactivated Your Relationship (And Didn't Tell You)
Complete guide to inactive relationships in Power BI: why they appear, how to detect them, USERELATIONSHIP, role-playing dimensions, and advanced patterns.
Rolling 12 months in DAX: the two-calendar solution
How to calculate rolling 12 months in Power BI correctly. Step-by-step DAX tutorial.
Rotating Measures in DAX: When your data won't stay put
Products that change categories break your DAX calculations. Here's the pattern to handle rotating dimensions correctly in Power BI.
VertiPaq for humans: how Power BI compresses your data
Value Encoding, Dictionary Encoding, and RLE explained without the academia. Why your model is 2GB when it should be 200MB.