How to Create a Dynamic File Path in Excel Power Query

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=v_zTtHuNoDw

How to Create a Dynamic File Path in Power Query • Pulling some information from different data sources is relatively easy nowadays. Thanks to Power Query as you don’t need to do it manually anymore or guessing an overwhelming VBA script just to get the right code for your data. Admit it or not, you’re investing so much time in searching for the formula/script in the internet and debugging errors just to get the task done. • This 10-minute video tutorial will help you how to make your data sources dynamic with the use of simple M script that you can add to refer to a named range in Excel. Let’s embrace this opportunity to learn new things. • Modify M Code: • Path = Excel.CurrentWorkbook(){[Name= Path ]}[Content]{0}[Column1], • Filename = Excel.CurrentWorkbook(){[Name= Filename ]}[Content]{0}[Column1], • Source = Excel.Workbook(File.Contents(Path Filename), null, true), • Practice File: • https://drive.google.com/drive/folder... • Creativity is the power to connect the seemingly unconnected. • William Plomer • ************************************************* • Want to learn more about Excel? • SUBSCRIBE NOW: • / @romeocostillas • YouTube Playlist: • • Excel Keyboard Shortcut Control Combi... • Or visit me on Facebook at / excelbyromeocostillas • See you there! • • Romeo Costillas • Microsoft Certified Solutions Associate BI Reporting • Microsoft Office Specialist Master • Microsoft Office Specialist Excel Expert • Microsoft Innovative Educator • Discrete Event Simulation Modeler • • Tagalog Excel | Filipino | Pinoy Excel | Excel Tagalog Tutorial | Paano Gamitin ang Excel • #excelbyromeocostillas #Excel #ExcelTips

#############################

New on site