Forum Discussion
How to reference a query column value in another query
Hi homboy27,
Thank you for reaching out to the Microsoft Fabric Forum Community.
To use a column value from one query as a dynamic parameter, create a separate query (e.g., EarliestDateQuery) that returns a single value like the minimum date. Then, create a parameter (e.g., EarliestDateParam) and set its value to reference that query. You can use this parameter in other queries for filtering. It updates automatically with data refresh, so you don’t need to enter the date manually each time.
Otherquery = Table.SelectRows(Source, each [SomeDateColumn] >= EarliestDateParam)If this solution helped, please consider marking the response as accepted and giving it a thumbs-up so others can benefit as well.
Best regards,
Prasanna Kumar
Hi homboy27,
We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.
If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution it helps others who might face a similar issue.
Warm regards,
Prasanna Kumar