Search This Blog

Monday, August 3, 2020

Passing Input Parameters into Power Query

In Power Query, you can set up a worksheet to take user input, perform calculations or other forms of data manipulation (or transformation) and output a specific table based on the user input. This would be an example of passing an input parameter to Power Query. Even though you could perform this with some combination of functions, pivot tables or slicers, the nice thing about Power Query is that the underlying steps can all be "hidden" from your user and you can just enable a one click does all for your user. This simple example in the video will show you how to pass a user parameter from Excel into Power Query.

No comments:

Post a Comment