Guest
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 05:43 06:34 Removing blank columns 08:01 Positional index operator 10:55 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 - FREE COURSE - Ultimate Beginners Guide To DAX - http://po
