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 is date table and also I have my table with data and column "date" format.

 

Please help me to write how to choose these dates in filter. Many thanks

 

1 Reply

  • 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.