Intermediate DAX

In Intermediate DAX, Angelica Choo Quan helps you move beyond basic measures and start writing calculations that behave consistently in real Power BI reports. You’ll learn how to use variables for cleaner, easier-to-debug DAX, how filter context actually shapes results in visuals, and how to build time intelligence calculations that answer common business questions like month-over-month and year-to-date performance. You’ll also explore the function families that unlock more flexible analysis, including X functions (row-by-row evaluation) and A functions (quick aggregations). Angelica closes by tying DAX back to governance and security considerations, so your calculations stay reliable when access and filtering rules are involved. By the end, you’ll have a stronger toolkit for building measures that are accurate, readable, and reusable.