Slicer with selected date range (-12 month jumps)

[Anonymous]

Hello,

i would like to have a slicer were everytime i select a Month and a Year it will return the relative -12 months before:

for example in the slicer: 

- I select March 2020 and returns  all dates until Februar 2019 (-12months)

- I select July 2019 and returns all dates until Juni 2018 (-12months)

therefore the selected time range is always fixed, how do i do this?

with the relative date panel i have to always input it manually i dont think this is the solution

thank you for the help!

Miguel

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the link down below and the picture, whether it is what you are looking for.

The measure is in the sample pbix file.

https://www.dropbox.com/s/zfpj7ugyk1cbel1/yukipilas.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[amitchandak]

@Anonymous , Based on what I got, you need an independent date table.

Refer to my video on that

Independent Date Table: https://lnkd.in/eAiWcWC

[Anonymous]

I have one 🙂 what do i need to build it additionally ?

[amitchandak]

@Anonymous , you are trying to build a table based on the slicer parameter?

if yes, that is not possible