Question: how to calculate percentage in power query?
Answer: 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.