Forum Discussion
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 parameter. I tried to filter using [Dimension] = parameter in the M query, but that does not work for multi-valued parameter. If I choose List.Contains ({Parameter},[Dimension]) I also get an error message "We vouldn't fold the expression...". Any idea on the correct syntax for filtering the table?
Thanks
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/
2 Replies
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/
Hi fduperier
How do you want to apply the multi-valued parameter to query the fact table? Suppose you have multiple start dates and multiple end dates, data in which date periods should be brought into Power BI?
Best Regards,
Community Support Team _ Jing
