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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.