topic Re: DAX comparion operations do not support comparing values of type date with values of type text- in DAX Commands and Tips

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

Anonymous — Thu, 02 Apr 2020 11:11:34 GMT

I am trying to create a column to popluate with certain words if certain criteria is met, however I get the the error below

DAX comparion 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. All dates have dates format. I will be grateful if someone can help me to solve the error and write the formula

UAT if
- a.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

Returned to Sender if
- UAT Returned Date not blank
- Project ID blank
Pending QC if
- FBOA_Approved_Date Blank
- Dsp_Assign_Date not blank
- FBOA_Denied_Date blank

Passed QC if
- FBOA_Approved_Date Blank
- Deployed Date blank

Deployed if
- Deployed Date not blank
- Status: CP created

Deployment Complete if
Reconciliation Completion Date not blank
Status: closed

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

Greg_Deckler — Thu, 02 Apr 2020 12:49:37 GMT

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Definitely recommend SWITCH(TRUE()...)

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

Anonymous — Thu, 02 Apr 2020 23:02:38 GMT

Thank you Greg. I though I posted it in right forum. I tried Switch function but I am still stuck