none
How to track Old data while data get refreshed and chage the same value RRS feed

  • Question

  • Help needed to rack old data in Power BI

    I have data set with which will be refreshed every month. I would like to calculate the revenue and MoM change of revenue for year.

    Ex:

    End of June month

    Month   July'19 Aug'19 Sep'19

    Est Rev  5000   8000    10000

    End of July month

    Month   July'19 Aug'19 Sep'19

    Est Rev  0        8500     8000

    Revenue at end of July 16500

    MoM Change = 16500-23000/16500

    Do we have any idea how can we store cumulative revenue for previous month (23000 in this case) to calculate the change?

    Tuesday, July 2, 2019 7:34 AM

Answers

All replies