← ClaudeAtlas

dax-referencelisted

Use when you need to know what a built-in DAX function does, its exact signature, what it returns, whether it is legal in a measure, a calculated column, a calculated table or a visual calculation, whether Microsoft discourages it, or which of several similar functions to reach for — and equally for the DAX language itself when no single function is in question, such as evaluation context, context transition, filter and row context, the query statements EVALUATE, DEFINE, MEASURE, ORDER BY and START AT, operators, data types, BLANK semantics, variables with VAR, and Microsoft's own best-practice guidance. The canonical reference for DAX. Triggers on "what does X do in DAX", "DAX function signature", "which DAX function", "difference between", "is X deprecated", "can I use X in a calculated column", "does X work in a measure", "what is evaluation context", "context transition", "DAX query syntax", "EVALUATE statement", "what does BLANK mean in DAX", "DAX operators", "DAX best practice".
CSalcedoDataBI/dax-for-agents · ★ 0 · AI & Automation · score 68
Install: claude install-skill CSalcedoDataBI/dax-for-agents
# DAX Reference The complete DAX function library, agent-native. Derived from `MicrosoftDocs/query-docs` (CC BY 4.0 — see [`NOTICE`](./NOTICE)), which has returned 404 since 2026-08; the same material is published on [Microsoft Learn](https://learn.microsoft.com/en-us/dax/). Annotated with the gotchas the docs leave out. > **Status.** `generated/` is built — 479 functions and 34 conceptual pages from > `MicrosoftDocs/query-docs@323524c`, plus **31 field notes**, each one measured > against a real model rather than asserted. > See [the design spec](../../docs/superpowers/specs/2026-08-06-dax-for-agents-design.md). ## How to use this **One hop. Do not read the whole library — it is ~376.000 tokens.** 1. Read **[`generated/catalog.md`](./generated/catalog.md)** (~14k tokens). Every function, one row each: name, category, return type, where it applies, one-line summary, and flags. 2. Find the function. Open its card: **`generated/library/<function>.md`**. 3. If the catalog row is flagged **★**, also read **`notes/<function>.md`** — that is the field knowledge that is not in Microsoft's docs. It sits outside `generated/` because it is written by hand. 4. If the catalog row is flagged **▶** — or, the same fact seen from the card, its frontmatter says `examples: N` with N greater than zero — the card links to **`examples/<category>/<function>.md`**: N queries **executed against a model that is in this repository**, each one published with the number the engine