Slinding calendars: show two calendars where the second one is the first plus/minus x days

[alecsonline]

Hi all, I am not succeeding in obtain this:

in a table showing a calendar on the first column, I should be able to show a second column that is still a calendar but reporting the dates "transposed" of 1 , 2, 3 etc (or -1,-2 etc. ) depending on a value flagged in a slicer.

In the image below is an example of the desired result (in this case flagging "-4" in the slicer)

If you like you can find here a .pbix file with calendar and slicer already on:

https://www.dropbox.com/s/bwms01x6r9xurwk/Sliding%20calendars.pbix?dl=0

Thank you all for any help!!!

[v-danhe-msft · Accepted solution]

Hi @alecsonline ,

Based on my test, you could refer to below measure:

Measure = CALCULATE(MAX([Date]))+SELECTEDVALUE(datechanging[dayschanging])

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[alecsonline]

Great thank you very much!!!! So simple! Tried many wrong ways.....