It’s a common task in Power BI to have to combine data from multiple worksheets in the same Excel workbook. For today’s tutorial, I’ll show how you can optimize your workflow and easily open data from multiple sheets and within an Excel file with one master query.

Melissa

***** Video Details *****
00:00 Introduction
00:22 Data set
00:39 The goal
01:07 File location parameter
01:57 Formula bar
02:16 Connecting files
03:09 Data range
03:34 Structure or layout of sheets
04:42 Bonds data
05:21 Removing blank rows
05:34 Record.FieldValues
05:43 List.RemoveMatchingItems
06:34 Removing blank columns
08:01 Positional index operator
10:55 Table.ColumnNames
12:10 Navigation
12:40 Transform nested tables
12:48 Adding security ticker
15:26 Repeating transformations
16:10 Let statement
17:34 Column profiling

***** 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://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial