DAX comparion operations do not support comparing values of type date with values of type text

[Anonymous]

I am trying to a create a column to populate with certain words if a criteria is met, however, I get 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"

What i want is  a column to say following.  I will be grateful if someone can help me to solve the error and write the formula. I tried writing both with Switch and If formula but same issue again and again.

• UAT if
  • Mgr_Approved_Date not blank
  • UAT_Date blank
  • Project ID blank

• Approved UAT if
  • UAT Date not blank
  • UAT Pass is True
  • Project ID blank

Switch(True(), 'Table'[Mgr_approved_date]<>"" && 'Table'[UAT Date]=""&& 'Table'[Project ID]="", "UAT",

'Table'[UAT PAss]"True" && 'Table'[UAT Date]<>""&& 'Table'[Project ID]="", "Approved UAT")

[amitchandak]

@Anonymous ,You have datediff to compare dates. isblank to check for blank values. And March 2020 support coalesce. means you can handle a null value.

if(isblank ([Date1]),,,

Or

if(not(isblank ([Date1])),,,

[Anonymous]

Hi @Anonymous ,

Can you try changing 'Table'[Mgr_approved_date]<>""  with ISBLANK( 'Table'[Mgr_approved_date])

Similarly for the other date .

Let me know if it worked.

Cheers

CheenuSing

[Anonymous]

@Anonymous Thank you for responding. I tried that and it gave me new error that it doesn't support True/False type. 

 i also tried the following in "Custom Column" of Power Query but it failed too 

if[Mgr_Approved_Date]<>"" and [UAT_Date]="" and [Project_ID]=""
then "UAT"
else if [UAT_Date]<>"" and [Project_ID]="" and [UAT_Passed]="True"
then "Approved UAT"
else if [UAT_Returned_Date]<>"" and [Project_ID]=""
then "Return to Sender"

else if [Dsp_Assign_Date]<>"" and [FBOA_Approved_Date]="" [FBOA_Denied_Date]=""

then "Pendnig QC"

else if [FBOA_Approved_Date]="" and [Deployed_Date]="" then "Passed QC" else if [Deployed_Date]<>"" and [Status]="CPCreated"

then "Deployed"

else if [Reconciliation_Complete_Date]<>"" and [Status]="Closed"

then "Deployment Complete"

else ""

[Anonymous]

Hi @Anonymous ,

I tried the following computed column in a table in my file and it worked perfectly

Test = IF( ISBLANK('Tool data'[Ship date]) && ISBLANK('Tool data'[FA date]) && 'Tool data'[Sort field] = "END OF LIFE" ,"YES","No")

Just check if your date columns are type date.

Cheers

CheenuSing