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
Thank you so much PhilipTreacy Im slowly getting a jist of typecasting functionality in DAX now.
Can you please also help me the logic of the question on the other link. Tagged you there
Anonymous
Yes I find it frustrating that columsn that obviously contain numbers are still imported as text.
Regards
Phil