Forum Discussion
Post ProdigyM Language: Access an element of a parameter list while filtering by text
Hi akhaliq7 please refer to the linked tutorial, it seems exactly what you need:
https://www.youtube.com/watch?v=gFqlfSckc5s
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
For my specific issue this can solved by using the or and creating more than one parameter, or in my case I created one parameter and hardcoded one value as that extra value was only to be used in one report,
= Table.SelectRows(#"Changed Type",each ([Department] = Department or [Department] = "Admin"))
Super UserHi akhaliq7 please refer to the linked tutorial, it seems exactly what you need:
https://www.youtube.com/watch?v=gFqlfSckc5s
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
akhaliq7This is not what I would like to achieve, I am looking for syntax that I can then use in my M Language, e.g. if I could access elements 2 & 3 in the parameter list which is sales and marketing I would like to change my m language to be the following:
m language:
= Table.SelectRows(#"Changed Type", each ([Department] = Department[1] or [Department] = Department[2] ))
Parameter List
Department
Values
Admin
Sales
Marketing