Forum Discussion

Helper II

4 years ago

Solved

Last year data calc

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

Thanks for your help,

cheers,

Anonymous
4 years ago
Use This Measure in your file.
calculate(CALCULATE([Sales MTD],DATEADD(Foglio1[Date],-1,YEAR),ALLEXCEPT(Foglio1,Foglio1[Date])))

Anonymous
Not applicable
4 years ago
Use This Measure in your file.
calculate(CALCULATE([Sales MTD],DATEADD(Foglio1[Date],-1,YEAR),ALLEXCEPT(Foglio1,Foglio1[Date])))
papuzu
Helper II
4 years ago
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
papuzu
Helper II
4 years ago
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