Transform Tab in Query Editor: Statistic option of query editor like absolute value, power, square root, log etc. in Power BI: Lesson-7 P-9

Transform Tab in Query Editor: Statistic option of query editor like absolute value, power, square root, log etc. in Power BI: Lesson-7 P-9

IT 06.03.2024   0 Comments  Add to Reading List

The "Statistics" options commonly available in Power BI's query editor are:

  • Absolute Value: Returns the absolute value of a number, ignoring its sign.
  • Power: Raises a number to a specified power value.
  • Square Root: Solve under the root of a number.
  • Logarithm: Computes the logarithm of a number with a specified base.
  • Exponential: Computes the exponential function of a number.
  • Factorial: Calculates the factorial of a number.

Lab Work:

"Statistics" options of Query Editor

1:- Absolute Value

Definitions: Absolute value (or modulus) | x| A real number x is a non-negative value of x regardless of its sign.

Example-1: The absolute value of 5 is 5, and the absolute value of −5 is also 5. The absolute value of a number can be thought of as its distance from zero along the real number line.

Example-2:

Here, |2| 2 is the distance from 0 (zero). Therefore, +2 and -2 are both at a distance of 2 from the origin. But distance is never measured in negative terms.

  • Return Absolute values in selected column
    • Transform --> Scientific --> Absolute Valye

Selected column with negative sign

after applyng the Absolute Value option

2:- Power

  • Return Power of values in selected column
    • Transform --> Scientific --> Power
  • 2.1:- Transform --> Scientific --> Power --> Square

  • 2.2:- Transform --> Scientific --> Power --> Cube
    • with datatype (Decimal Number)

  • with datatype (Text)

  • 2.3:- Transform --> Scientific --> Power --> Power...

then you have final view with power 3

3:- Square Root

  • Return Squre Root values in selected column
    • Transform --> Scientific --> Square Root

4:- Exponent

  • Return exponent numbers of selected column
    • Transform --> Scientific --> Exponent

Example-2 of Exponent

5:- Logarithm

  • Logarithm - Base 10
  • Return logarithm Values of base 10 and  Natural log
    • 5.1:- Transform --> Scientific --> Logarithm --> Base 10

5.2:- Transform --> Scientific --> Logarithm --> Natural

Thanks for reading of Scientific option of query editor like Absolute, Sqare root, Power, Logarithm etc

Microsoft Power BI Table of Contents: Lessons Index

Tags: