Power Query: Handling Percentages & Percent Totals
(NOTE: This replaces a previous video that had audio problems.)
Calculating percentages in Power Query is not as easy as it is in native Excel.
First, when using the interface to calculate values in 2 different columns, you have to select the columns in the right order.
Second, If you have a column of amounts and want to get each entry's percentage of the total, that's not straightforward. We end up making a parameter of the total and then calculate the percentages using that parameter.
#PowerQuery
#Percentages
#PercentTotals
For a list of my Excel courses at Lynda/LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2