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