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

View all the Fabric Data Days sessions on demand. View schedule

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

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.