Forum Discussion
Solved
Values 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?
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?
thank you so much AIB and Alexis i will share PBIX as soon as i can.Thanks
Hello Alexis & AIB,
Thank you so much for your suggestion.I have changed the "Contract Not Yeat Started" to 00000 and that works for me.