cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Khalidc
Frequent Visitor

Present following twelve months based on slicer

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:

Khalidc_1-1654796865019.png

This is what I get: 

 

Khalidc_2-1654797032366.png

 

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:

 

Khalidc_0-1654796820748.png

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors