Forum Discussion
Using one column value and filter another query
Hello everyone, I am pretty new to power query so need to ask if this is possible. The senario is I have a store proc that return 6 columns one of the column has ClientID base the the client ID t...
Hey Nepal101 !
I don't know if I understand, but, you can merge the two queries in one. Load the 2 queries on Power Query and then merge then in new one choosing the best join option for your scenario. Read more about merge queries here:
Merge queries overview - Power Query | Microsoft Learn
PS.: Another way to get the desired result is merge directly in SQL if you have access to write it.
Best Regards,
Marcel