Hi all,
I'm trying to solve an issue, in my table I've got a date column (deadline) and a status column (Status). Now I want to add a measured column called (overdue). When field (deadline =<today) and status IN "Ongoing", "Planned" field (overdue) should be filled with Yes.
I tried the following:
Overdue = IF(Sheet1[Deadline] < TODAY() & Sheet1[Status] in {"Ongoing", "planned"}, "True","False")
But then I receive the following error:
DAX comparison operations do not support comparing values of type Date with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values.
My simple table looks as follow (field Overdue is of course not existing):
| Country | Property | Type | Description | Year | Status | Deadline | Responsible auditor | Overdue |
| Netherlands | Office A | Audit | WELL V2 | 2022 | Complete | 31/03/2022 | Janssen | No |
| Netherlands | Office B | Audit | WELL V2 | 2022 | Ongoing | 30/11/2022 | Pieters | No |
| Germany | Office C | Audit | WELL V2 | 2022 | Ongoing | 31/10/2022 | Beckers | Yes |
| Germany | Office D | Audit | WELL V2 | 2022 | Planned | 31/12/2022 | Beckers | No |
Hopefully anybody can help me out with this, thanks in advance for your response.
