IF Statement that updates a date based on another column

[KieronMullan]

Hi Folks, hope someone can help.  This is super easy in Excel, but I am struggling in PBI.

I have a situation where I need to add x number of days from an existing date column IF the first 4 letters of another column contain a specific set of letters.  I have created the formula below, but am getting an error that says 'DAX comparison operations do not support comparing values of type Integer with value of type Text.

The outcome I am trying to achieve is if the Project ID column record contains 'REQD' as the first 4 letters, then add 10 days to the 'Issue_Date, otherwise, leave the Issue date as is.  Can anyone help with the formula needed?

Corrected Issue Date = IF(LEFT(TABLE A[Project_id],4 = "REQD"),TABLE A[Issue_Date]+10,TABLE A[Issue_Date])

Thanks in advance.

[MFelix · Accepted solution]

Hi @KieronMullan,

Believe your issue is with the parenteses try this instead


Corrected Issue Date = IF(LEFT(TABLE A[Project_id],4) = "REQD",TABLE A[Issue_Date]+10,TABLE A[Issue_Date])

Regards,
MFelix

[KieronMullan]

Thank You MFelix - really appreciate the quick response which did exactly what I needed

Cheers