Dynamic query parameters multi-value

[fduperier]

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

[v-jingzhang]

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

[AlexisOlson · Accepted solution]

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/