Forum Discussion

tejapowerbi123's avatar
tejapowerbi123
Helper 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
Helper V
7 years ago

I tried below,

Start Date = IF([Valid Price]=" ","N","Y")

but getting the same error.

AlB's avatar
AlB
Community Champion
7 years ago

tejapowerbi123

Sure, 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

  • tejapowerbi123's avatar
    tejapowerbi123
    Helper V
    7 years ago

    Hi AIB,

    problem is that VALID PRICE is a calculated column and i am not able to see in QUERY EDITOR.

    • AlB's avatar
      AlB
      Community Champion
      7 years ago

      tejapowerbi123

      Hang on, I'm getting confused here. If it's a calculated column,  how have you been able to create one with numbers and text? What type is that column?

      • tejapowerbi123's avatar
        tejapowerbi123
        Helper 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,