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

Cumulative total

The cumulative total pattern allows you to perform calculations such as running totals You can use it to implement warehouse stock and balance sheet calculations using the original transactions instead of using snapshots of data over time For example in…  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