cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Nimmi Frequent Visitor
Frequent Visitor

slicer filter with time interval

Hi Team,

 

I have to create a slicer filter with date column intervals, colunm name current_end_date in my tableCapture5.PNG

 

if (interval([Current End Date] - today(), 'd') < 0, 'expired',
if (interval([Current End Date] - today(), 'd') > 0  and interval([Current End Date] - today(), 'd') < 30, 'less than 30 days',
if (interval([Current End Date] - today(), 'd') > 31 and interval([Current End Date] - today(), 'd') < 60 , 'less than 60 days',
if (interval([Current End Date] - today(), 'd') > 61 and interval([Current End Date] - today(), 'd') < 90 , 'less than 90 days',
'more than 90 days'))))

 

like this kind of calculations. So the Slicer should display 5 options like above image.

 

Please help me on this.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: slicer filter with time interval

Hi @Nimmi,

 

You can add a column and try this formula.

 

Column =
VAR interval =
    DATEDIFF ( [Current End Date], TODAY (), DAY )
RETURN
    SWITCH (
        TRUE (),
        interval < 0, "expired",
        interval > 0
            && interval < 30, "less than 30 days",
        interval > 31
            && interval < 60, "less than 60 days",
        interval > 61
            && interval < 90, "less than 90 days",
        "more than 90 days"
    )

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
shakeelsyed Frequent Visitor
Frequent Visitor

Re: slicer filter with time interval

Create a new calculated column with "IF" statement and use the same formula you mentioned below.

 

Hope that resolve your query.

 

Regards,

Shakeel

Community Support Team
Community Support Team

Re: slicer filter with time interval

Hi @Nimmi,

 

You can add a column and try this formula.

 

Column =
VAR interval =
    DATEDIFF ( [Current End Date], TODAY (), DAY )
RETURN
    SWITCH (
        TRUE (),
        interval < 0, "expired",
        interval > 0
            && interval < 30, "less than 30 days",
        interval > 31
            && interval < 60, "less than 60 days",
        interval > 61
            && interval < 90, "less than 90 days",
        "more than 90 days"
    )

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.