LOG10

How to Use the Power BI DAX function LOG10

To use the LOG10 function in Power BI DAX, follow these steps:

Step 1: Enter the Function

To use the LOG10 function, you need to enter it into a DAX formula. The general syntax for the LOG10 function is as follows:

LOG10(Number)

Here, "Number" is the value that you want to calculate the logarithm of.

Step 2: Add the Number Argument

Once you have entered the function, you need to add the number argument. This is the value that you want to calculate the logarithm of. For example:

LOG10(100)

This will calculate the logarithm of 100 with a base 10.

Step 3: Use the Result

Once you have entered the function and added the number argument, the LOG10 function will return the result. You can then use this result in your calculations and visualizations.

Example Usage

Let's say you have a table in Power BI that contains sales data for your company, and you want to calculate the logarithm of the total sales for each month. You can use the LOG10 function to do this as follows:

LOG10(SUM(Sales[Total Sales]))

This will calculate the logarithm of the total sales for each month with a base 10.

The LOG10 function in Power BI DAX is a powerful tool for dealing with large numbers. By using it, you can convert these numbers to a more manageable scale, making it easier to work with them in your calculations and visualizations. So, if you're working with large numbers in Power BI, be sure to give the LOG10 function a try!

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)