Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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..
Solved! Go to 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"),
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.
Regards,
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"),
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |