DAX expression for Last 90 days Sales value for every month.

[ajayemmadi1]

Hello Guy's,

I am looking for last 90 days Sale Value for every month. I could able to achieve only last 90 days amount of current month but not for every month. Can anyone help me out in writing a DAX expression for the same issue. I am expecting it as per the below format.

Regards
Ajay Emmadi

[Balraj]

Orders last 90 days =

CALCULATE(

[Orders],

DATESINPERIOD(

'Date'[Date],

MAX('Date'[Date]),

-90,

DAY

)

)

[AiolosZhao · Accepted solution]

Hi @ajayemmadi1 ,

Maybe my solution is a little stupid, I assume that you have a index for your month sort like below:

Measure 2 = CALCULATE(SUM(Table6[Sales]),FILTER(ALL(Table6),Table6[Index] <= MAX(Table6[Index]) && Table6[Index] >= MAX(Table6[Index]) - 2))

Please try.

Aiolos Zhao