Add Custom Relative date slicer

[SUMESHKUMAR22]

Hi Team,

In Urgent Need!

Problem statement:

Request to be able to find Opportunities that haven’t been updated recently. I was thinking that we could accomplish by adding a ‘Before’ option to the “Last Updated Date” filter? The ‘Before’ option would filter records where the “Last Updated Date” value is [x] amount of [days, weeks, months, etc] before the current date. (Refer below Image)

But adding a before in the Relative date is not possible so, Is there feasibility to add this requirement??
Pbix attached hereby.

 

Thanks in advance:)

[collinq]

Hi @SUMESHKUMAR22 ,

If I am understanding your issue, why not just put a filter on the date visual to only get x amount of days before curent date?  That would be just in the filter pane and not "in" the visual but it should do what you want.

[SUMESHKUMAR22]

For example, If I'm selecting the before selection with [x = 30] days then it should show up records only where the last updated date is Before 30 days NOT Last 30 days. Hope I'm able to clear that.

[collinq]

Hi @SUMESHKUMAR22 ,

Ok, I think I understand.  So, you will probably need to do a DAX field to get that date range and then use it.  So, it would be something like this (I have not had time to test this but the point is to get the dates in the selected period in your slicer and then get the previous 30 days only).

30DaysOut = CALCULATE(('Table Name'[Field name]),DATESINPERIOD('Date Dim'[Date],NEXTDAY('Date Dim'[Date])-30,DAY))