How to get a calculated column of Current, Past Due, Near-Due Date from a column of Due Dates?

[ymirza]

I have a Due Date column, and I want a filter that should show "Current", "Past Due", and " Near-Due Date".

When the Actual Due date is near 30 days (or more) from today(), it should show "Near-Due Date"

I tried a calculated column, but it only returns "Current" and "Past Due"

Assignment Due Status = IF(DATEDIFF('TABLE'[AssignmentDueDate], TODAY(), DAY)<0, "Current", IF(DATEDIFF('TABLE'[AssignmentDueDate], TODAY(), DAY)>=0, "Past Due", IF(DATEDIFF('TABLE'[AssignmentDueDate], TODAY(), DAY)<= 30, "Near Due")))

Please help!

[Fowmy · Accepted solution]

@ymirza 

Set it up this way:

Assignment Due Status = 
var __date = DATEDIFF(TODAY() , 'TABLE'[AssignmentDueDate], DAY) return
SWITCH(
    TRUE(),
    __date > 0 && __date <= 30, "Near Due", 
    __date <= 0, "Past Due",
    "Current"
)