Forum Discussion

tejapowerbi123's avatar
tejapowerbi123
Icon for Helper V rankHelper V
7 years ago
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...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    7 years ago

     

    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?

tejapowerbi123's avatar
tejapowerbi123
Icon for Helper V rankHelper V
7 years ago

Hi,

Please see below forumula 

Valid Price1 = IF((' Contracts'[Start Year]+[ Start Month]/12)<=([AUP Current Year]+[AUP Current Month]/12),[Monthly Discounted Price]&"" ,"Contract Not Yet Started")

***All columns data type is whole number,

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
7 years ago

 

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?

  • tejapowerbi123's avatar
    tejapowerbi123
    Icon for Helper V rankHelper V
    7 years ago

    thank you so much AIB and Alexis i will share PBIX as soon as i can.Thanks

  • tejapowerbi123's avatar
    tejapowerbi123
    Icon for Helper V rankHelper V
    7 years ago

    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.