Previous 4 Quarters in DAX as a measure

[WhaleWatcher222]

Hi Experts

How would you calculate as a mesure the previous four quarters in DAX - the previous quarter is easy

PREVQ Sales = Calculate( sum(sales[SalesAmt]), DATESQTD(ENDOFQUARTER([DATESADD[DATE[DATE],-1,QUARTER))))

[rajendraongole1 · Accepted solution]

Hi @WhaleWatcher222 - Create below measure to get the last four quarters

Prev4Q Sales =
CALCULATE(
SUM(Sales[SalesAmt]),
DATESINPERIOD(
'Date'[Date],
ENDOFQUARTER('Date'[Date]),
-4,
QUARTER
)
)

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[WhaleWatcher222]

let me test