Get totals from all months before selected months (WIP overview projects)

[BobKoenen]

Hi guys and Girls,

I am trying to create a dynamic project overview in a Table with a Month filter. The goal of the overview is to see how much work is yet to be invoiced in a certain period. I need to be able to select one month or multiple months. And the first column always needs to show the total of al the months in this year before the selected month in the date filter. 

project	Begin WIP	Time spend in $	invoiced	End WIP
A	-50	100	150	-100
B	200	0	100	100
C	0	50	0	50
D	50	0	50	0

However I cannot figure out how to build the measure to that the [begin WIP] always takes -1 from selected month. Can you help me?

[BobKoenen · Accepted solution]

I already found it. I used the datadd; -1; month and it workd 🙂