You’ll most probably encounter data analysis requirements wherein you’ll need to group and rank values in order to show the needed insights and trends within your data set. In this video, Melissa is going to deal with a scenario that requires using custom grouping and ranking in Power Query.

***** Video Details *****
00:00 Introduction
00:22 Objective
01:01 Data set
01:14 Table.Partition
04:59 Table.AddRankColumn
07:08 Filter
08:24 Table.RemoveColumns
10:24 Combine tables

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – rel=”nofollow”>http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerQuery #PowerQueryTutorial #PowerBI #PowerBIDesktop #PowerBITutorial