Forum Discussion

snaraya's avatar
snaraya
Icon for Helper II rankHelper II
2 years ago

Custom slicer with conditional values

Hi All,   i have two columns Due Date Status & overdue within 5days created on the basis of one numrical calculated Days Overdue column which is created using date column.   Days Overdue = IF(IS...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi snaraya

 

I reproduced your formula with test data, and perhaps you could modify the Due Data Status formula to take the following form:

 

Due Date Status =
SWITCH (
    TRUE (),
    ISBLANK ( 'Table'[Days Overdue] ), "No Due Date",
    'Table'[Days Overdue] > 0, "Over Due",
    'Table'[Days Overdue] >= -5
        && 'Table'[Days Overdue] <= 0, "Upcoming Overdue within 5 days",
    'Table'[Days Overdue] < -5, "Not Overdue"
)

 

 

 

Is this the result you expect?
 

Best Regards,

Community Support Team _Yuliax

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