Forum Discussion
Solved
Dynamic query parameters multi-value
Hello I have a direct query facts table that I filter using single valued parameters for start and end date. That works fine, and I would like now to filter my table using a multi-valued paramete...
If Parameter is a list, then you don't want to wrap it in another set of {}. Maybe try just
List.Contains(Parameter, [Dimension])Reference: https://blog.crossjoin.co.uk/2021/10/10/multi-value-parameters-in-power-query-online/
AlexisOlson
Super User
Super UserIf Parameter is a list, then you don't want to wrap it in another set of {}. Maybe try just
List.Contains(Parameter, [Dimension])
Reference: https://blog.crossjoin.co.uk/2021/10/10/multi-value-parameters-in-power-query-online/