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
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
Hi,
Thank you for your response,
Maybe, Which the function to returns the result for the last day-1?, ( in this case is day 25).
Can you give me some advices.
littlevillage There was no function to return the day prior to the last as it wasn't in the original request. However, I created a third query which you can reference. In this case, enter the specific date you want to return in F2 and refresh the query "SpecificDate" .
I dont see the attach file,
can youi check back, please.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