Calculate Last Year Sales based on Max function in DAX

[satishkurra]

Hi

I'm currently using below expression for YTD Sales. The reason i used Max here is user can slice based on Year selection dynamically

vEngYearYTD = CALCULATE(

SUM(Raw_New[Engagement Revenue]),

FILTER('Link',Link[Fiscal Year]=[vMaxYear]),

FILTER('Raw_New',Raw_New[Date]<=[vMaxDate])

)

vMaxYear = Max(Link[Fiscal Year])

vMaxDate = Max(Raw_New[Date])

Now i want to compare the same period last year. I do not want to use same period last year as it goes only year back.

Thanks

Satish

[Anonymous]

Try this:

Same Period Last Year = CALCULATE([YTD measure], PARALLELPERIOD('Report - New Cut In'[Date], -12,MONTH))

[satishkurra]

This works if no year selected from slicer. But if we select year, it is blank. The reason is we are using Max in YTD Measure

[v-cherch-msft]

Hi @satishkurra 

It seems you may change the formula with Link[Fiscal Year]=[vMaxYear]-1 to get last year.Here is the similar post for your reference.If it is not your case,sample data and expected output will be helpful to provide an accurate solution.Please share the .pbix file.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,
Cherie