DAX formula for dates

[cubedweller]

I am new to DAX.

I would like to create a variable called Completed Past Due.
How would I write this logic as a DAX expression?
if (task_due_date < task_completion_date and
task_completion_date is not missing and
status = "completed")
then "Yes" else "No"

Thank you.

[deldersveld · Accepted solution]

Something along the lines of =SWITCH(TRUE(), Table[task_due_date] < Table[task_completion_date] && NOT(ISBLANK(Table[task_completion_date])) && Table[status]="completed", "Yes", "No")