Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
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
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()...)
Thank you Greg. I though I posted it in right forum. I tried Switch function but I am still stuck
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 14 | |
| 11 | |
| 9 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 28 | |
| 20 | |
| 19 | |
| 17 | |
| 12 |