DAX Mathematical Functions

Mathematical Functions within Microsoft Power BI.

A. ABS: 

AbsoluteValue = ABS(-10) 

This example returns the absolute value of -10, resulting in 10.  

B. SQRT: 

SquareRoot = SQRT(25) 

This example calculates the square root of 25, resulting in 5. 

C. POWER: 

PowerResult = POWER(2, 3) 

This example raises 2 to the power of 3, resulting in 8. 

D. LOG: 

NaturalLog = LOG(10) 

This example calculates the natural logarithm of 10, resulting in approximately 2.3026. 
  
E. ROUND: 

RoundedValue = ROUND(3.14159, 2) 

This example rounds the number 3.14159 to 2 decimal places, resulting in 3.14.