Forum Discussion

karbofosss's avatar
karbofosss
New Member
8 years ago

Show different dates in diagram

Hi   I have a slicer with dates, where I can select only one value. Then I want to show a measure rolling year (12months before) for selected date and for date a year ago.   my table for slicer ...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

So, what you will want to do is to make sure that your date table is NOT related to your fact table. Use the date table for the slicer. Then, you will need to write a measure that gets the MAX of your date table and only returns a value if the current date is within your 12 month window, otherwise BLANK. Use the date from your fact table and measure in your visual.