Present following twelve months based on slicer

Khalidc — Thu, 09 Jun 2022 17:54:54 GMT

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:

Re: Present following twelve months based on slicer

tamerj1 — Thu, 09 Jun 2022 18:13:11 GMT

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

topic Re: Present following twelve months based on slicer in DAX Commands and Tips

Present following twelve months based on slicer

Re: Present following twelve months based on slicer