Forum Discussion
How can use Power Query as a VLOOPUP replacement.
Here is a similar approach but instead of returning results that match the current day it returns the results for the last day in the appended table (whether that's today, yesterday, etc...).
I'm not sure what you have in mind for the general/continued workflow. Are you planning to create a new tab for each day, then create a new query to pull the new table, then revise the append query to include the latest?
Using "Folder" as a data source could automate pulling in & appending new data, if you were to save a new workbook for each day in the same folder. Just an idea. Happy to elaborate.
I'm not sure if I'm blind but I cannot see where to attach a file as you both appear to have done. Here is a link to it anyway.
https://1drv.ms/x/s!AiAvVNTmKlkpiq5NrkrSAS5X1ppvew?e=S0kjmb
littlevillage I made the changes in the original file linked previously. You should be able to see the most recent changes using the first link I posted. Let me know if this is not the case.
Dexter
https://1drv.ms/x/s!AiAvVNTmKlkpiq5NrkrSAS5X1ppvew?e=S0kjmb
Thank you very much.
You give me a lot of useful.
Yes, the power query couldn't find date 31.08.
The specific day is the best way for this.
Regard,
Phan.