Using Cell values as Parameters in Power Query

[lorenzo06]

I have the following filter set up.

= Table.SelectRows(#"Promoted Headers", each ([Transaction_Type] <> "I") and ([Contract] = "contract name") and ([Month] = 5))

I would like it so where [Month] = 5, the 5 is actually pulled from a cell reference so the end user can look at different months with ease.

Any suggestions?

 

[RoryA]

Welcome to the forum.

Have a look at Ken's blog post here: https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/