Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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.

    Download the PBIX

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Anonymous 

It's not ideal to look at copied data like that, you can't tell if numbers are stored as text or numbers.  Much better to supply the PBIX file.

But, is your Executed Flag column Text data type? It should be Whole Number.

And there's no column called [202/3 Flag] in the data on that page you linked to. It should also be a numeric data type like Whole Number. Is it Text?

Regards

Phil