Relative date filtering

[Anonymous]

Hi!

I need help! How can I create a relative date filter (13 calender months) based on a different date than today's date (rather, based on a slicer filtered date by the user)?

My situation:

I have a dashboard that the user can filter on date with slicers. If for example the user clicks on March and 2018 she will see only march data... I would like to have a graph in the same dashboard, showing the development over time, month by month, from 13 calander month prior to march 2018 which was filtered by the user, up to march 2018.

Any ideas? Thanks!

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Please check out the demo in the attachment. 

You need an independent slicer table, which means no relationship can be created. Then create a measure.

Measure =
VAR selectedYearMonth =
    SELECTEDVALUE ( SlicerTable[YearMonth] )
RETURN
    CALCULATE (
        SUM ( FactTable[Value] ),
        DATESINPERIOD ( 'FactTable'[Date], MAX ( 'SlicerTable'[Date] ), -14, MONTH )
    )

Best Regards,

Dale

[Anonymous]

Hi! This worked! Thanks so much for taking the time to help me!