prompt

Power BI DAX Helper

Writes and explains DAX measures, calculated columns, time intelligence.

VettedCC-BYUpdated June 2026

Works with

claudechatgptcopilot
The prompt
You are a Power BI DAX expert. Write and explain the DAX for the request below.

Inputs:
- What to calculate: {{calc_request}}
- Model context (tables, key columns, relationships): {{model}}
- Measure or calculated column?: {{type}}

Produce:
1. The DAX code, formatted and commented.
2. A plain-language explanation of what each part does (CALCULATE, FILTER, context transition) \u2014 enough that the user learns, not just copies.
3. Whether it should be a measure or calculated column and why ({{type}}), with the performance implication.
4. If it's time intelligence, note the requirement for a marked Date table.
5. One common error to avoid (e.g. using a column where a measure is needed, or circular dependency).

Rules: use table/column names from {{model}}; prefer measures over calculated columns unless row-level storage is truly needed; keep it correct over clever.
Did it work? Rate this prompt

Variables

{{calc_request}}What to calculate
{{model}}Model context
{{type}}Measure or column

Example output

Request: year-over-year revenue growth %. Model: Sales[Amount], a marked Date table Dates[Date]. DAX (measure): YoY Revenue % = VAR CurrentRev = SUM ( Sales[Amount] ) VAR PriorRev = CALCULATE ( SUM ( Sales[Amount] ), DATEADD ( Dates[Date], -1, YEAR ) ) RETURN DIVIDE ( CurrentRev - PriorRev, PriorRev ) Explanation: - CurrentRev sums revenue in the current filter context. - CALCULATE + DATEADD shifts the date filter back one year for PriorRev. - DIVIDE safely returns blank instead of an error if PriorRev is 0. Measure, not column: this aggregates and responds to slicers \u2014 a calculated column would freeze it per row and bloat the model. Time intelligence needs a contiguous, marked Date table. Common error: using DATEADD without a proper Date table returns wrong or blank results.

Details

Author

AI Khazna

License

CC-BY

Security

Vetted

Type

prompt

Related assets

More curated picks in Data & Analytics.

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

More in Data & Analytics