Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Change Value of Power Query Variable for End User

Hello,   I hope to allow end users to change the value of variable(s) used in Power Query, whether through slicers, field parameters, or any other methods.   Some additional context: I imported...
Need Help
AmiraBedh's avatar
AmiraBedh
Super User
2 years ago

You can use a param like for example :

 

 

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    FilteredRows = Table.SelectRows(Source, each [Column1] > Threshold)
in
    FilteredRows

 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello,

 

Thank you for your reply! To provide more context, my threshold variable will be checking across multiple columns. I want to select data that with [Column 1]'s value  > [variable of interest] or [Column 2]'s value > [variable of interest] or [Column 3]'s value > [variable of interest].

 

An example would be adding a threshold column:

#"Add Threshold Column" = Table.AddColumn(#"previous line", "Threshold", each if [Column 1] > [variable of interest] or [Column 2] > [variable of interest] or [Column 3] > [variable of interest] then [Column 1] else null)

 

Here, I would like the variable of interst to be adjustable by the end user.

 

Would this be possible? Thank you!