Скачать или смотреть Create Dynamic File Paths Using Excel Like a Pro!

Learn how to create Dynamic File Path in Power Query using Excel Named Range. Join this channel to get access to perks:
https://www.youtube.com/ChethanaPixel...

So, WATCH this video now and THANK me later

🚀📈 Join us on this #Excel & #PowerBI adventure and Don't forget to hit that like button, SUBSCRIBE for more Excel mastery, and let the dynamic journey begin!

#powerquery #dynamicfilepath #mcode

00:00 Introduction
00:41 Create Named Range in Excel Power Query
01:31 Create function in Power Query
02:44 Update File Path in M-Code Power Query
03:40 Testing Dynamic File Path in M-Code Power Query
04:40 Create Macro to Auto Refresh
06:41 Wrap-Up!!!

New PERCENTOF function:    • NEW Excel Function - PERCENTOF with Comple...  

GROUPBY and PIVOTBY functions:    • Master the New GROUPBY & PIVOTBY Functions...  

XLOOKUP Guide:    • The Ultimate XLOOKUP formula Tutorial (The...  

Hand Drawn Charts in Excel:    • Hand Drawn charts in EXCEL to draw attenti...  

Python in Excel Part 1:    • Introducing Python in Excel - Financial An...  

Python in Excel Part 2:    • Python in Excel - Dynamic Financial Dashbo...  

Power Query Series:    / playlist  
list=PLAJojq_HX3tYVVd0bT42Qsu0GwFa9z5-9

JOIN us for more FUN:
   / @chethanapixel  

Play List:    / chethana  

Instagram:   / ​  

Facebook:   / chethanapixel  

Twitter:   / chethanapixel  

Thank you!!!