Last year data calc

[papuzu]

hello there 

there is no way I'm able to calculate Last Year (or Previous Year data) on a table I'm putting here as example 

I'm either following the MTD approach or the DATADD criterion to move period backwards when selecting timeframe of the sum but none of them working 

What am I doing wrong ? 

here is the link with .pbix file 

https://www.dropbox.com/s/hulu6owt4ikfktc/LastYear.pbix?dl=0

Thanks for your help,

cheers, 

p

[papuzu]

Hello , there is a problem 

https://www.dropbox.com/s/hulu6owt4ikfktc/LastYear.pbix?dl=0

I have just added a cluster to better represents sales and PY Sales measure repeat same figures all rows. What is wrong ? 

Thanks 

[papuzu]

https://www.dropbox.com/s/hulu6owt4ikfktc/LastYear.pbix?dl=0

Hello

adding a cluster on table section all figures got repeated with no sense. What am I missing out ? 

Thanks 

[Anonymous · Accepted solution]

Use This Measure in your file.

calculate(CALCULATE([Sales MTD],DATEADD(Foglio1[Date],-1,YEAR),ALLEXCEPT(Foglio1,Foglio1[Date])))