DAX LLM Benchmark v2

The DAX LLM Benchmark v2 shows that the latest frontier models write DAX very well, and that the model generation matters more than the vendor. This post describes how we built the benchmark, how we read its results, and what…  Read more

DAX Patterns

Week-related calculations

This pattern describes how to compute week-related calculations such as year-to-date same period last year and percentage growth using a week granularity This pattern does not rely on DAX built-in time intelligence functions All the measures refer to the fiscal…  More on DAX Patterns


Microsoft Press

The Definitive Guide to DAX, Third Edition

The Definitive Guide to DAX is an authoritative resource for mastering the DAX language, which is pivotal for creating measures for semantic models in Microsoft Power BI, Fabric, Analysis Services, and Excel.
Read more