DAX - Same Day not date last year

[Anonymous]

Hi,

I would like to have a measure which calculates the same day (Sunday to Sunday) last year.

So it should be input date -364 instead of Samerperiodlastyear DAX as input date -365

Tried below from a previous post ( https://community.powerbi.com/t5/Desktop/Dax-Help-Same-Day-not-date-last-year/td-p/203055), but does not work, the measure gives me blank.

Measure 2 = calculate(sum('Table'[Amount]),sameperiodlastyear(DATEADD(Calendar[Date],-1,DAY)))

Any helps are greatly appreciated!

[amitchandak · Accepted solution]

seems fine

Only thing is it should be 364

Measure 2 = calculate(sum('Table'[Amount]),sameperiodlastyear(DATEADD(Calendar[Date],-364,DAY)))

 If possible please share a sample pbix file after removing sensitive information.
Thanks

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601