Power Query Parameters

[dicken]

Hi,
if you use the option to use a query as the ' suggested value' what does it do,
I created a query = {"A","B","C", "D"} ,

and put this into the suggested value for new parameter and A; it does not give a list , B; it does not restrict the values I can enter manually to
one from that list,
so in the below I could enter any value I like or null. so what does it do? I

=

Table.SelectRows(Custom1, each ([#"Ttable "] <> parameter))

Richard

 

[smozgur]

Try List.Contains function to check if a value exists in a list or not.

Sample (I assume your column name with space is correct):

let
    Custom1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    parameter =  {"A","B","C", "D"},
    Result = Table.SelectRows(Custom1, each not List.Contains(parameter, [#"Ttable "]))
in
    Result

 

[dicken]

Try List.Contains function to check if a value exists in a list or not.

Sample (I assume your column name with space is correct):

let
    Custom1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    parameter =  {"A","B","C", "D"},
    Result = Table.SelectRows(Custom1, each not List.Contains(parameter, [#"Ttable "]))
in
    Result

Puzzled, what does that have to do with the parameter, I entered the list I created as the values of the parameter, but they are
not or don't seem to be, they neither limit the entries I can make nor create a list to pick from so what does it do?

 

[smozgur]

Please try posting some sample data (source and desired output - make sure it is not sensitive real data) and your entire query.

 

[dicken]

Please try posting some sample data (source and desired output - make sure it is not sensitive real data) and your entire query.

How, I can't see where to attach a file, also it's a fairly straing forward question ;

A ; create a query = { 1,2,3} ,
B I create a table = #table( {"A"} , { {1}, {2}, {3}} )
use the first as the values of a new parameter,

then use that parameter in another ; P= parameter ;

Table.SelectRows( Source,(A)=> A [A] = P )

But I can make the values in P anything I like, it is not limited to the values 1,2,3 they do not create a list to choose from as using the list option would so
what does it do? if you don't know fine, but I can't keep asking the same question,

Richard.

 

[RoryA]

It's a parameter and works the same way as any other parameter.

they do not create a list to choose from as using the list option would

Not sure what you mean by that exactly?

 

[dicken]

It's a parameter and works the same way as any other parameter.


Not sure what you mean by that exactly?

Hi,
when you say it works as any parameter, I don't see that it does, if I create a list eg {1,2,3}, then use that as the value in new parameter
type any suggested value query; and the the name of the query {1,2,3} = Parameter ,

if i then use that eg ;

 Table.SelectRows ( Source ,each [TableA] > Parameter1)

I can enter any value as current value or change it to anything in the parameter box, 1 , 100, "XXX", so what does entering a query as the parameter
achieve.
what is it supposed to do, what is the difference between using a query as suggested value and 'Any value'?


Richard

 

[RoryA]

The parameter is a list, so using > Parameter1 doesn't really make any sense. It would allow you to have a dynamic filter option for a query for example, where you could filter for In Parameter1.

 

[dicken]

The parameter is a list, so using > Parameter1 doesn't really make any sense. It would allow you to have a dynamic filter option for a query for example, where you could filter for In Parameter1.

 

[dicken]

Sorry for not responding sooner,
Well this is the question, why use a query as a parameter if it has no effect on that parameter, eg
if i have a table of rows a,, b, c , d , e and then create a list { a, b, c } and use the parameter option query,

Table.SelectRows( Source, each [Tabel] = Parameter1) , this works, but I can type in a , b but x , z or anything else I choose,
so why use a query in a parameter, if I use the list option in new parameter and again ; a, b c, they are values of that parameter,
which is what I would have expected from the first.
Richard