Is there a way to create a measure for the cumulative sum (last column in the table) that takes into account also opening balance (before January in the table). So what I would need is to sum balance and cumulative balance from previous month. Also, that when I'm using slicer for years, then in 2019 it would take the Dec cumulative balance from 2018.
You show 2 Tables in your measure but your formula only refers to the Data Table. Please share the actual data layout. Also, the opening balance of 1500 should have some date against it. So please assign some data to that figure. Share data in a format that can be pasted in an Excel file.
This almost worked, but what is still tricky, is that I have an another slicer for different products and in case slicer is on, then it shows cumulative total for all the products (the above data was for one product only).
Is there a way to add this as well in the measure?
I could add January 2018 date to the opening balance as it should be included in January's total. But the data is from the same table, just year is different (I wanted to show that when I use year slicer on date, then it would still calculate correct cumulative).