Power Query: % of total

[Lance Pretorius]

In Power Query how do you add a custom column that displays row total as % of column total?
See Below

Thanks in advance

Index	Name	Total	Column to be added		Column to be added formula
1	A	100	4.76%​		=$D4/SUM($D$4:$D$9)
2	B	200	9.52%​
3	A	300	14.29%​
4	B	400	19.05%​
5	A	500	23.81%​
6	B	600	28.57%​

 

[GraH - Guido]

If your table would be in Excel

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Index", Int64.Type}, {"Name", type text}, {"Total", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each List.Sum(Table.Column(#"Changed Type","Total"))),
    #"Inserted Percent Of" = Table.AddColumn(#"Added Custom", "Percent Of", each [Total] / [Custom] * 100, type number)
in
    #"Inserted Percent Of"

Note the step Percent Of is doable via the ribbon:
Select column total then column custom then apply as in screenshot

 

[Chihiro]

This sort of calculation is best done in DAX. It's more efficient.

However, there are many ways to do this. Using GUI as GraH showed above for one.

Using calculated column like below.

=[Total]/List.Sum(Source[Total])

 

[Lance Pretorius]

It worked,
Thank you for Helping