Forum Discussion

ravitejaballa's avatar
ravitejaballa
Helper III
4 years ago

Filter Slicer on multiple condition

Hi,   I have data like below and I have a slicer (Expired, Expiring Within 90 Day, Terminated) using which I should filter data Expired = Should show all records where the End date is less than to...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

ravitejaballa , try with this change

 

Slicer Flag = 
var EndDateDiff = DATEDIFF(NOW(), Data[End Date], DAY)

var terminated = IF(Data[State] = "inactive", TRUE(), FALSE())
var within90days = IF(AND(EndDateDiff > 0, EndDateDiff <= 90), TRUE(), FALSE())
var expried = IF(EndDateDiff < 0, TRUE(), FALSE())

RETURN
Switch( True() ,
terminated, 3, 
expired,1 ,
within90days,2, 
0)