IF ELSE DAX Calculation for Overdue column

[Anonymous]

I'm trying to create a new table that tells me if a Task is overdue or not.

The logic behind it would be, IF [Task Satus] is NOT equial to "Completed" AND [Due Date] is > TODAY, then the statement is TRUE.

but IF [Due Date] is < TODAY, then statement is FALSE

IsOverdue =

SWITCH (

TRUE(),

Compliance_Tasks[Task Status] <> "Completed"

&& Compliance_Tasks[Due Date] > TODAY() , "TRUE",

Compliance_Tasks[Task Status] <> "Completed"

&& Compliance_Tasks[Due Date] < TODAY() , "FALSE",

)

[V-pazhen-msft]

Hi, @Anonymous 

Can you make your question clear, because your formula should work (btw, you should remove the comma at the end).

Best, Regards,

Paul Zheng