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!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I am having trouble with data types thats causing an error in a formula. I consistently get this error "DAX comparison operations do not support comparing values of type Text with values of type Date. Consider using the VALUE or FORMAT function to convert one of the values." YET my data types are seemingly correct.
Here is my formula:
@redgerly Seems like you are trying to determine if the facility_name (assuming this is text) is <= a date value, which is highly unlikely to work out or be meaningful in any way.
'public patient_stays_detailed_view'[facility_name] <= StayDate)
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 10 | |
| 6 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 19 | |
| 14 | |
| 11 | |
| 8 | |
| 8 |