I am struggle with creating a cummulative total measure as per last year. In accounting we usually report last year net income and this will be rolled forward in the balance sheet. I need to create a measure that gives me the cummulative balance as of last year.
If I select any month in the current year, the measure should give me the same number as of last year.
|2015||1||100||0||No previous year|
|2019||2||800||1500||Cummulative balance is the same as the ending balance of 2018|
|2019||2||500||1500||Cummulative balance is the same as the ending balance of 2018|