Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

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

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
2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

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()...)



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.