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.