Forum Discussion

A-Rae's avatar
A-Rae
New Member
3 years ago
Solved

DAX formula for Percentage between two columns

Hello, I'm new to Power BI/DAX.  I need to create a column on my table to show the percentage of the New Sales column compared to the salesperson's Quota column (see pic), their % Achievement .  For...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi A-Rae 

    try to

    1)create a measure with this code:

    Achievement％=
    FORMAT(
        DIVIDE(
            SUM(Sales[Sales]),
            SUM(Budget[Quota]),
         ),
        "0.0%"
    )
     
    2)then plot any visual with this measure.
Nico_Kl's avatar
Nico_Kl
Frequent Visitor
3 years ago

To create a column that shows the percentage of New Sales compared to the salesperson's Quota in DAX, you can use the following formula:

 

New Sales % = DIVIDE(New Sales, Quota)

 

This formula will divide the New Sales column by the Quota column and return the result as a decimal value. To convert the decimal value to a percentage, you can multiply the result by 100 and add the % symbol.

Here is an example of how the formula could be used in DAX:

 

 New Sales % = FORMAT(New Sales / Quota, "0.00%")

 

This formula will divide the New Sales column by the Quota column, format the result as a percentage with two decimal places, and add the % symbol.

 

Please note that the exact syntax and names of the columns and functions may vary depending on your specific data set and Power BI configuration.