Forum Discussion

smartp121's avatar
smartp121
New Member
5 years ago

Need help on a Row level data Calculation

Hi Friends, I need some help with this calculation, Don't know how to make this work   I have data in the following format    Year Month Revenue  MTD Revenue  2020 4   489,611   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  smartp121 ,

 

According to your calculation rules, The MTD Revenue calculation should be like Month month 5-Month 4 = month 5 MTD.

 

The situation should look like the following table:

 

For example, May’s MTD Revenue should be -181400, but your MTD Revenue is 31404.

 

If my answer is not what you need, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • smartp121's avatar
    smartp121
    New Member
    5 years ago

    Anonymous 

     

     

    you can see the calculation in the fig above 

     

    MTD Revenue is D7-D6 and I need to calculate MTD Revenue column, ( Column J)