I am trying to create a Work in Proces overview which shows the total amount to be invoiced. This overview has a from till slicer on month level. The first column always needs to show the cumulative values of all months before the first month selected in the slicer.
See a simpel model for example from month 2 til month 4:
| || ||Selected months|| |
| ||Start Wip||Worked hours ||Written off||Invoiced||End Wip|
If I would change the Slicer to from month 5 til month x The value of the [Start WIP] would be the [end Wip] in the table above.
The end Wip = (begin WIP+worked hours) - (written off + Invoiced)
I am struggeling to get the formula for the [Start Wip], This is essentially the cumulative [end Wip] of the month before the selected month.
However I think I am getting into a Loop and I cannot figure out how to het the total from the selected month -1.
Hope you can help me