Forum Discussion

Helper I

9 years ago

Solved

Passing Parameters to Query Editor from another table

I have a table imported to PowerBI Desktop that will end up in the powerbi.com portal. This table has a DateKey column in it (we'll call this OrderDateKey). I am going to be joining that to a DateDim...

ankitpatira
9 years ago
aellison One of the new feature for query parameters is to be able to use other queries as a source for it. So you can create two new queries that gives max and min values and set that as a source for your parameters and then use those parameters to filter DateDim table.

v-qiuyu-msft

Community Support

9 years ago

Hi aellison,

As ankitpatira suggested, you can specify the query parameter values from other list query output. In your scenario, you can create two list query which returns both MIN and MAX of the OrderDateKey. Refer to below:

1. In Query Editor, check the OrderDateKey column then select "As a New Query".

2. In the new query, check Sort Descending. Then use "Keep Top Items" to only keep the MAX value. Use the same way to get a list which contains the Min value.