Filter table through list query

[Anonymous]

I have created a list query which holds only one value. i want to use that value to filter another table.

But Filter accepts only Parameter or manual selection and not a query.

when i want to assign this value to parameter its not taking that value instead it asks for current value. ( here i want it should take the value from the query as is, becuase that value will be dynamic.

How to do this? Please assist..

List Created:

Unable to assign this value to Parameter:

i want to use that value in if condition to filter an another table in power query:

But Parameter is not taking the value from list query. How to achieve it dynamically? Please assist..

[v-cherch-msft]

Hi @Anonymous 

Based on my research,it's not supported yet.You may vote for this similar idea.For further,please check if this article could help.

https://community.powerbi.com/t5/Desktop/How-to-dynamically-set-the-Parameter-Current-Value/td-p/89106

Regards,

[Anonymous · Accepted solution]

Hi v-cherch-msft ,

Thank you for your inputs and assistance.

i also tried modifying query in M query without using Parameter and it worked fine.

i just put MonthListQuery (created table/list query) in M query to filter the table.

   #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each [Month_End] = #"MonthListQuery"),