Can we use Parameter for several text values at once?

[karo]

Hi,

I would like to ask if there is a way to use Parameter for several text values at once?

I am trying to use parameter to reduce data when importing from cube.  For single text value is working perfectly for example Poland, but I would like to find a way to do it for example for Poland AND Denmark. 

Regards,

Karo

[lbendlin · Accepted solution]

In boolean language it's not Poland AND Denmark, it's Poland OR Denmark.  Depending on your cube query you should be able to use enumerations (ie comma separated lists) of your desired values.

[column] IN ("Poland","Denmark")  etc.

[lbendlin · Accepted solution]

In boolean language it's not Poland AND Denmark, it's Poland OR Denmark.  Depending on your cube query you should be able to use enumerations (ie comma separated lists) of your desired values.

[column] IN ("Poland","Denmark")  etc.

[karo]

Hi @lbendlin , Thank you for reply, however I am not sure if we are on the same page. I am trying to find a way to use parameter for several text values at once to reduce data when importing from cube.

= Table.SelectRows(#"Added Items", each [Geo.Country] = Parameter or [Geo.Country] = Parameter)

Where  Parameter  represents Poland and Parameter represets  Danmark.

[lbendlin]

=Table.SelectRows(#"Added Items", each List.Contains(Parameter,[Geo.Country]) )

[karo]

Expression.Error: We cannot convert the value "Poland" to type List.  😞

[lbendlin · Accepted solution]

I see, you are trying to convert the suggested parameter values to a list?

= Table.SelectRows(Source, each List.Contains(Value.Metadata(Parameter)[List],[Geo.Country]))

[karo]

@lbendlin Thank you so much! 🙂

[lbendlin]

no, thank you - Learned something new about Metadata today 🙂