Forum Discussion
deb_power123
Helper V
Helper VGetting DAX error: DAX doesn't support comparing values of type Text with type Date
Hi All, I have a Student table with columns:- StudentID StudentName AdmissionDate LastAttendanceDate DateLeft Location Studenttype I have a calendar table connected to student table...
It looks like your field 'student'[DateLeft] is set as type text. Select the field in the fields bucket and under "Column Tools" in the ribbon, set the field type to type Date:
PaulDBrown
Community Champion
Community ChampionIt looks like your field 'student'[DateLeft] is set as type text. Select the field in the fields bucket and under "Column Tools" in the ribbon, set the field type to type Date:
deb_power123Helper V
Helper VThankyou, yes it was a miss from my end.It automatically became text, not sure how.The forumla now works fine
- PaulDBrown
It was propably formatted as text in the import phase. Power Query has a habit of establishing field data types automatically, but doesn't always get it right.
you can check by opening the query and checking the code in the "Changed type" step, and edit accordingly if need be)