Forum Discussion
tejapowerbi123
Helper V
Helper VValues comparision number to text
Hi, Can any one help for below error? In excel I have a valid price column and in that column has $amount and “Contract not started” comments, but when I try to replicate below formula in power...
The data type of column [Valid Price] cannot be whole number or decimal if you have any rows with "Contract Not Yet Started". It would have to be text. I guess you don't have any rows that have that value?
AlB
Community Champion
Community ChampionSure, you're still doing the same, comparing a number to text.
You could use the query editor to easily replace all occurrences of your text string with a number
tejapowerbi123Helper V
Helper VHi AIB,
problem is that VALID PRICE is a calculated column and i am not able to see in QUERY EDITOR.