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: