sum of budget 6 next months (YYYYMM)

[#1]

Hi,

got a table with Period (YYYYMM), Item, Budget and Instock:

Now, if I select one period, I will have a Straight table showing the Instock for that selected period and the sum of Budget for the 6 next month (the selected period not included).

For example, (for the data above), if I select Period 201510 it should be like this:

[Gysbert_Wassenaar]

Try: sum({<Period={">=$(=only(Period))<$(=Date(Addmonths(Only(Period),6),'YYYYMM'))"}>}Budget)

[sunny_talwar · Accepted solution]

Try this expression:

Sum({<Period = {"$(='<=' & Date(AddMonths(Max(Period), 6), 'YYYYMM') & '>' & Date(Max(Period), 'YYYYMM'))"}>}Budget)

[#4]

this solution worked too, but it uses the selected period and 5 next month, instead of the next period and 5 next month