Error while using Power function

[rahul632soni]

Hey Team 

I am Using Power Function to create Calculated Column,  i am using below formula :-

BDamage = POWER((ABS(ga_acm_driveline_damage_interpolated[gear_torque])),8)*ABS(ga_acm_driveline_damage_interpolated[gear_cycle])

I am getting Following Error - 

An argument of function 'POWER' has the wrong data type or the result is too large or too small.

Kindly Assist

Regards

Rahul Soni

[ppm1]

Not sure what is going on. It worked for me (BDamage column). You could always try it in the query editor instead (Damage column) with this expression.

= Number.Power(Number.Abs([torque]), 8 ) * Number.Abs([cycle])

I would check for any bad values in your torque column. Doing it in the query editor is better practice would also help identify any individual rows that may be causing the error. Trying to do it simply as a measure instead of a column would be even better.

Pat

[ppm1]

This page give more info on the ranges for each data type. Can you share some of your two values? If you change the 8 to 2 (for example), do you still get the error?

Pat

[rahul632soni]

@ppm1 

Yes when i am using 2 instead of 8 , still getting error , even for 1 instead of 8 i am getting error .

[ppm1]

Your error gave two explanations. You've ruled out one, so what is the data type of the gear_torque column?

Pat

[rahul632soni]

@ppm1 

Hey , For both gear_Cycle and gear_Torque data type is  decimal number .

Both Column Range is below for refrence :- 

Regards

Rahul Soni