Скачать или смотреть 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.


🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~-~~-~~~-~~-~