In this video, Melissa demonstrates her approach in solving Excel BI’s Stacked To Ordered Power Query Challenge. The objective for this challenge is transform a stacked data into a tabular format with the results showcased in a descending order.

Excel BI’s Stacked To Ordered Challenge: https://bit.ly/3SRptdB

***** Video Details *****
00:00 Introduction
00:51 Creating lists
01:18 Drill-down
01:27 Splitting lists
02:04 Assigning field names
02:47 Transforming into tabular format
03:16 Table.AddRankColumn
04:44 Reordering columns

***** 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 – 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 #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial #PowerQueryChallenge #DataChallenge