Reverse Cummulative Sum
Hello All, I need help with creating a column/measure in Power BI Desktop. I want to create a reverse cumulative sum based on multiple columns below is the dataset(example): The last column is the result I want (cumm_qty): Example: for the combination: "20-DL-1051001002-2021" (has three rows for one for each month ) now I want a "cumm_qty" in reverse order i.e for 3rd month the value is -30495, for 2nd month it's 30495, for third month its 19000. So for 3rd month the value should be same (-30495), for 2nd month the value should be (-30495+30495 = 0), for 1st month it should be (-30495+30495+19000 = 19000). So If I add one more month then the calculation should be: 4th month = 4th month qty 3rd month = 4th month qty + 3rd month qty 2nd month = 4th month qty + 3rd month qty + 2nd month qty 1st month = 4th month qty + 3rd month qty + 2nd month qty + 1st month qty Please help me with this. Regards Shubham
