The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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)