cancel
Showing results for
Did you mean:  Helper V

## DAX percentage column

Hi,

how to get a percentage column as NotOverdue. Example formula given below.

Need help on this.

 ID Country NotOverdue Overdue NotOverdue % ??? 1 Germany 6 2 Example formula:  (NotOverdue/Notoverdue+Overdue )*100 2 India 7 2 3 Norway 5 3 4 Italy 3 1 5 Canada 8 0 6 USA 7 0 7 UAE 6 1 8 UK 5 2 9 France 4 4
1 ACCEPTED SOLUTION  Resolver III

Hi MuraliPrasathS,

Please fin below y possible solution.

Step 1) Create a calculcated column with the following formula (my table is named t_2).

percentage not overdue = t_2[NotOverdue]/(t_2[NotOverdue]+t_2[Overdue]) Step 2) Change the format of the column to percentage. I hope this helps.

Best regards

Mikelytics

----------------------------------------------------------------------------------

2 REPLIES 2  Super User II

You can also use the divide function in a calculated column:

Column = DIVIDE('Table'[NotOverdue], 'Table'[Notoverdue]+'Table'[Overdue])

In a measure you can use the following formula:

Column = DIVIDE(SUM('Table'[NotOverdue]), SUM('Table'[Notoverdue])+SUM('Table'[Overdue]))

And then change the format of the column to Percentage  Resolver III

Hi MuraliPrasathS,

Please fin below y possible solution.

Step 1) Create a calculcated column with the following formula (my table is named t_2).

percentage not overdue = t_2[NotOverdue]/(t_2[NotOverdue]+t_2[Overdue]) Step 2) Change the format of the column to percentage. I hope this helps.

Best regards

Mikelytics

----------------------------------------------------------------------------------    