Forum Discussion
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...
Use This Measure in your file.
calculate(CALCULATE([Sales MTD],DATEADD(Foglio1[Date],-1,YEAR),ALLEXCEPT(Foglio1,Foglio1[Date])))
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