How to make dynamic the path to the data source files in Power Query in Excel | L0027
Автор: Celia Alves - Solve & Excel
Загружено: 2022-05-20
Просмотров: 26760
There are situations where the path to the data source for a query built with Power Query in Excel needs to be adjusted based on certain conditions. It may be because you want the query to look into a different file or folder, or it also could be that you are working on a shared folder (with Dropbox, for example), and you need Power Query to adjust the path based on the user's name. There are several ways to solve these challenges. In this session, I will teach my preferred method.
________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________
---
Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn: / celiajordaoalves
Facebook: / solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel
YouTube: https:www// / celiaalvessolveexcel
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
