Forum Discussion
How can a certain query take a specific date from another query?
I have a certain query with lots of past and future dates, also I have added columns in it. Let's call it query number 1
My goal is that query number 1 will take a specific date from another query...
Hello Kacol ,
Don't create query2 with yesterdays date. Instead of that create a parameter in Power Query Editor for yesterday's date and use that parameter to filter this table.
Please refer below video for details:
Power Query Parameters - Dynamically Change the Output of Your Queries Depending on Their Value - YouTube
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Thanks for trying to help, but it still didn't solve my problem. I can't figure out how I still filter query number 1, what I saw in the video is just a parameter in the form of text.
I'm still not sure how to automatically filter by yesterday's date.