Forum Discussion
Solved
YTD calculation
Hi everyone, I need to calculate: 1.- YTD both columns 2016 and 2017 2.- % variation 2017 vs 2016 should be -17% 2016=209.300, but it's wrong. This is the actual formula, the 2017 is cor...
MontsePuig,
Please review this modified PBIX file.
Regards,
Lydia
Measure = CALCULATE ( Value , DATESYTD ( 'Date' [Date]))
Assume you have a date dimension table named "Date". This should work for you...