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('PQI Lote'[P Value])
P Lote = SQRT(ROUNDUP('PQI Lote'[P Value],1))
 
But I have an error in both of the calculated columns about the value being too big or two small, 
 
I would appreciate some help!
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:

     

     

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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:

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Try
     
    P Lote = ROUNDUP(SQRT('PQI Lote'[Z Value]),1)
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Anonymous  thanks for replying, unfortunately that formula didn't worked

      the error was the same 

      Any other idea?

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

     

    What is the Error? 

    Also just to make sure your [P Value] column is of type Decimal?