Home · Business tools · Describe the number you want in Power BI and get the DAX measure
Describe the number you want in Power BI and get the DAX measure
'This month against the same month last year, by branch' is easy to say and hard to write. Get the DAX measure and a way to check it.
The prompt · ChatGPT
Write a Power BI DAX measure for me. What I want: [e.g. sales this month vs the same month last year, by branch]
The full prompt is free – sign up in 10 seconds
Free account: every prompt, one-tap copy, saved favourites.
Already have an account? Log in
No password needed. We email you a sign-in link.
What you get (sample answer)
Sales This Month YoY =
CALCULATE(SUM(Sales[Amount]), DATESMTD('Date'[Date]))
- CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(DATESMTD('Date'[Date])))
Needs a marked Date table. Check: North Sep 12,400 vs last Sep 11,100 → measure shows 1,300.
% change: DIVIDE([Sales This Month YoY], CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(DATESMTD('Date'[Date])))).The prompt · Copilot
Write a Power BI DAX measure for me. What I want: [e.g. sales this month vs the same month last year, by branch]
The full prompt is free – sign up in 10 seconds
Free account: every prompt, one-tap copy, saved favourites.
Already have an account? Log in
No password needed. We email you a sign-in link.
What you get (sample answer)
Sales This Month YoY =
CALCULATE(SUM(Sales[Amount]), DATESMTD('Date'[Date]))
- CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(DATESMTD('Date'[Date])))
Needs a marked Date table. Check: North Sep 12,400 vs last Sep 11,100 → measure shows 1,300.
% change: DIVIDE([Sales This Month YoY], CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(DATESMTD('Date'[Date])))).Copy your table and column names from the Power BI field list.
Paste the prompt above into any assistant.
In Power BI, create a new measure and paste the DAX.
Why it helps
You know which number the boss wants on the report but DAX defeats you, so you export to Excel and do it by hand every month.
Tools
Paste the prompt, fill the blanks, copy the draft.
- Microsoft Copilot — required. Works with the business tool named on this recipe. You stay in control of what gets sent.