Sqrt in Column

[Anonymous]

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!

[pranit828 · Accepted solution]

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:

[richbenmintz]

Hi @Anonymous,

What is the Error? 

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

[Greg_Deckler]

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

[Anonymous]

Thanks for repplying @Greg_Deckler , yes sure

 

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

Any ideas?

[Anonymous]

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

[richbenmintz]

Hi @Anonymous,

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

[Anonymous]

Try

P Lote = ROUNDUP(SQRT('PQI Lote'[Z Value]),1)

[Anonymous]

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

the error was the same 

Any other idea?