DAX code help

[JamesMurg]

Please help, we are trying to create visuals and for some reason our DAX code is showing an error
DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

But we have changed the format of both columns to date, could anyone shed any light on this please?

Column = IF('Findings'[Evaluation Date]="",IF('Findings'[Publish +90 days - Evaluation Due Date]>=TODAY(),"Outstanding","Overdue"),IF('Findings'[Publish +90 days - Evaluation Due Date]>='Findings'[Evaluation Date],"On Time","Late")

Thanks

James

[Samarth_18 · Accepted solution]

Hi @JamesMurg ,

Please try below code:-

Column =
IF (
    'Findings'[Evaluation Date] = BLANK (),
    IF (
        'Findings'[Publish +90 days - Evaluation Due Date] >= TODAY (),
        "Outstanding",
        "Overdue"
    ),
    IF (
        'Findings'[Publish +90 days - Evaluation Due Date] >= 'Findings'[Evaluation Date],
        "On Time",
        "Late"
    )
)

and also change the datatype of column to text.

[JamesMurg]

You are amazing!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Thank you so much 😀

[JamesMurg]

Thanks Marek

This solution didnt work 😭

I am still looking for some help on this solution please?

James

[marek_zarzycki]

Hi,

When you're using double quotes "", it's a text. In your first IF, you are comparing date column with text. This is the reason of the error you get.

Try using ISBLANK() or LEN() = 0, depending on what values you are expecting in the column.

IF(ISBLANK('Findings'[Evaluation Date]),IF('Findings'[Publish +90 days - Evaluation Due Date]>=TODAY(),"Outstanding","Overdue"),IF('Findings'[Publish +90 days - Evaluation Due Date]>='Findings'[Evaluation Date],"On Time","Late")

or

IF(LEN('Findings'[Evaluation Date])=0,IF('Findings'[Publish +90 days - Evaluation Due Date]>=TODAY(),"Outstanding","Overdue"),IF('Findings'[Publish +90 days - Evaluation Due Date]>='Findings'[Evaluation Date],"On Time","Late")

Good luck 😉