how to calculate percentage in power query?
['Within Power Query click Add Column -> Custom Column.', 'In the Custom Column dialog box enter the following formula: =[Headcount] / List.Sum(#"Changed Type"[Headcount])', 'Change the formula to fit your scenario: ... ', 'Give the custom column a useful name, such as % of total, then click OK.']