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,
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