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?

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi tejapowerbi123

It is not allowed to compare text and numbers. 

Maybe use a number code for "CONTRACT NOT STARTED", like a negative number that I guess wont come up in prices? 

 

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

    I tried below,

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

    but getting the same error.

    • AlB's avatar
      AlB
      Icon for Community Champion rankCommunity 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
        Icon for Helper V rankHelper 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.