smeautomation
Log inSign up free

Home · Business tools · Describe the number you want in Power BI and get the DAX measure

Just ask 2 min

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.

Updated 17 Oct 2026

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.

Sign up free to copy

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])))).

Loading the outline…