Get the data from the most recent file in a folder with Power Query

preview_player
Показать описание
This video how you can connect an Excel file to a folder with Power Query and bring the data of the most recent file in that folder into Excel. The particular situation used in this video also includes an example of how you can apply a left outer join to consolidate your data.

Рекомендации по теме
Комментарии
Автор

Good video Celia. Thanks for telling us the query refresh order - that is a great tips. I look forward to more videos.

GrainneDuggan_Excel
Автор

Good Video.. nice way to extract if you are working with the latest file

ExcelExciting
Автор

I'm so confused. Why not just filter "Is Latest" on Date Modified within Power Query?

brianferris
join shbcf.ru