Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sqrt in Column

Hello Everyone!   I want to calculate the SQRT of a column, I have a table like this:  I just need de Sqrt Value of the "P Value" column, i use the following formula:    P Lote = SQRT('PQ...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous 

     

    The problem lies in the data type used for this calculated value

     

    I recreated your scenario and below is the formula I would use.

    P Lote = SQRT(VALUE('PQI Lote'[P Value]))

     

    Below is the ouput I get:

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Anonymous - Can you display the full value of your P Value column?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for repplying Greg_Deckler , yes sure

     

     

    I can not even use the roundup() funtion because it brings up an error

     

    Any ideas?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      This should work. Can you share a sample PBIX file with us? 

      • richbenmintz's avatar
        richbenmintz
        Resident Rockstar
        6 years ago

        Hi Anonymous,

         

        This is very likely a data type issue, please ensure that your P Value column is of type decimail or currency