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

Frequently asked questions

What is the Power BI DAX Helper prompt?

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

Which AI tools does Power BI DAX Helper work with?

It works with claude, chatgpt, copilot.

Is Power BI DAX Helper free?

Yes, it is free to use under the CC-BY license.

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