How to reference a query column value in another query

[homboy27]

I have a dashboard, where I am trying to get this value from a table and I want to use this value to be updated in parameters every time. This would save me from always having to put in todays date in parameters everyday. 

[v-pgoloju]

Hi @homboy27,

Just a gentle reminder  has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

[v-pgoloju]

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

[v-pgoloju]

Hi @homboy27,

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful  this will benefit others in the community as well.

Best regards,

Prasanna Kumar

[v-pgoloju · Accepted solution]

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