Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |