Late Task DAX Flag

[jimmyg706]

Hi Everone

I was wondering how best to approach this with an additional column measure

I have table with a list of tasks and each one has a status and a due date.

I was wondering whether to use a Switch Function or something else.

Below is a mock up.

I really just want a flag if the due date has passed  + but it needs to ignore any task with a staus of complete so lines 3 & 4 would be flagged as late

Line 1 is complete - so its done - i.e we dont care

Line 3 is a future task- I said mark as NA ; it could 

Task Status	Due Date	Late Flag - DAX (switch/if function)
Complete	15/02/2024	NA
In Progress	01/01/2024	Late
To Do	15/02/2024	NA
Backlog	02/01/2024	Late

Task Status	Due Date	Late Flag - DAX (switch/if function)
Complete	15/02/2024	NA
In Progress	01/01/2024	Late
To Do	15/02/2024	NA
Backlog	02/01/2024	Late

I do have a field in my dataset which does the following based on that due date you see on Column 2

Days Till Due Date = DATEDIFF(today(), POAP[Due Date],DAY)

Advice appreaciated

Cheers

Jimmy

[jimmyg706]

@ryan_mayu 

Indeed my explanation was well , very poor.

Here is a visual of my table with some sensitve data removed 

So each task has a due date and also a status.

If the due date (date that it must be marked as Complete) is late, I want to flag this.

Now I could use conditional formatting to make it RED?

Maybe I could add an additonal column with a switch function?

Now the key thing here is that if a task is complete - it cannot be late. So completed tasks will have a due date in the past; they must not be flagged as they are done.

So sample data

Task Number	Task Description	Task Status	Due Date
1	Design	Complete	15/12/2023
2	Build	In Progress	01/01/2024
3	Test	To Do	10/01/2024
4	Deploy	To Do	02/01/2024

Screenshot of above in XLS is in Fig 1

Notice Task 2 & 3 are RED as they are late i.e the due date has passed and the task is not complete.

Notice Task 1 is complete; Due date is in the past; we dont care as its complete.

Task 4 - Its in the future - Basically ignore unless its late.

Fig 1 - Sample XLS mock up

So I dont mind adding a conditonal column to give a status like late task or it can be done via some other mean i.e conditional formatting?

So thats about it,  How would you do this:

If Task Due date has passed and task is not complete show red; else do nothing

Cheers 

Jimmy

[ryan_mayu · Accepted solution]

@jimmyg706 

is this what you want?

[ryan_mayu]

could you pls provide more sample data and the expected output? can't totally get your points based on just four rows of simple data.