Forum Discussion

MontsePuig's avatar
MontsePuig
Frequent Visitor
9 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    MontsePuig,

    Please review this modified PBIX file.

    Regards,
    Lydia

MontsePuig's avatar
MontsePuig
Frequent Visitor
8 years ago

Hi Lydia, thank you very much for your help.

 

I understand your idea, I have reproduced your instructions but I think something is wrong. The result of YTD For 2016 and YTD For 2017 are very high numbers.

 

In my example, the numbers are correct but I don't know how to calculate variation % YTD in a current Month (November)

Here you are a .pbix file

 

 

Thank you very much, :smileyhappy:

Anonymous's avatar
Anonymous
Not applicable
8 years ago

MontsePuig,

Please review this modified PBIX file.

Regards,
Lydia