Present following twelve months based on slicer

[Khalidc]

Hi

I am trying to present a 12 months future period which should be based on the value in the slicer selected. So if I select 2022 june, it should show the values from 2022 july - 2023 june. I have tried several "all" and "filter" formulas but without luck.

The slicer used:

This is what I get: 

This is what it should be, please note that it should show only the values of the respective month and not an aggregate of all 12 months in one column:

[tamerj1 · Accepted solution]

Hi @Khalidc 

you need to to have a future date table. Follow this https://youtu.be/d8Rm7dwM6gc let me know if you need further help