Forum Discussion
Comparing values of type text to integer
Hi, Although I have heard of this error "You cannot compare values of type text to integer" a lot of times before, Im still not able to figure out what conversion I need to make with my below cal...
Hi Anonymous
Your [202/3 Flag]column was Text and it needed to be Whole Number type.
I've changed it and now your Calculated Column code works.
Regards
Phil
Anonymous
It's hard to say without seeing your data.
Somewhere in that code you're comparing a text value with a number.
Regards
Phil
Here is the data. This question is linked with this
https://community.powerbi.com/t5/Desktop/For-Each-and-Exists-clause-implementation-in-DAX/m-p/1654336/highlight/false#M662465
You can refer this as well