In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
DAX Measures for Power BI or Power Pivot
Prompt
Product: {{POWER_PRODUCT}}
Data model: tables, key columns, relationships (one-to-many direction), and which table holds dates: {{DATA_MODEL}}
The measure in business language, including exclusions: {{MEASURE_IN_WORDS}}
How it will be sliced (by month, region, product) and any filter it must ignore: {{SLICING_AND_FILTERS}}
Write the measure. Rules:
- Use only the tables and columns I listed; if one is missing, ask.
- Write a measure, not a calculated column, unless you explain why a column is needed.
- Use VAR and RETURN for readability, DIVIDE for ratios, and CALCULATE where the filter context must change. Explain each in one sentence.
- For time intelligence, say that it needs a proper date table marked as one.
- Explain how row context and filter context apply to this measure.
Output: the measure, the explanation, and a test: a small table of figures I can calculate by hand and the value the measure should return in a visual filtered to each. Name two ways it could return a wrong total (for example a many-to-many relationship) and how to check.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“DAX Measures for Power BI or Power Pivot” is a free prompt for ChatGPT in the Coding & Software category, 191 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{POWER_PRODUCT}}, {{DATA_MODEL}}, {{MEASURE_IN_WORDS}}, {{SLICING_AND_FILTERS}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 8 times.
Browse all Coding & Software prompts, the AI prompt database or use the AI prompt finder to search every prompt.