Power Query Parameters give you the flexibility to dynamically change the output of your queries depending on their value. As Power Query records the transformation steps, it includes many hardcoded values within the M code.
What if we want to change these values? We could edit the query each time, which would be very timeconsuming. Or we could create parameters!
Parameters in Power Query are really easy. In this video you will learn how to create a Parameter in Power Query as well as create a parameter in an Excel Cell.
You can download the practice example here: https://buymeacoffee.com/missmicrosof...
00:00 Introduction to Parameters
01:15 Creating the Query
02:31 Creating the Parameter
03:43 Assigning the Parameter to the Query
05:42 Creating More than One Parameter
07:43 Creating a Power Query Parameter in an Excel Cell
✅ Please see link to video mentioned in this video:
Power Query Advanced Editor: • Getting Started with the Power Query ...
Create a Dynamic File Path Change the Power Query Source Based on a Cell Value: • Create a Dynamic File Path Change t...
Power Query Custom Functions: • Power Query Custom Functions Easily...
✅ If you would like to subscribe to The Query Editor Newsletter for more Power Query content:
https://thequeryeditor.beehiiv.com/
✅ If you would like to connect on LinkedIn:
www.linkedin.com/in/missmicrosoft
✅ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link:
☕https://www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
/ @missmicrosoft
✅ For more Power Query videos please use the links below:
Power Query in Excel Beginners Tutorial: Combine Multiple Excel Sheets, Automate & Transform Data: • Excel's Power Query: The Ultimate Beg...
Power Query Age Analysis Create an Excel Age Analysis Report Using Power Query: • Power Query Age Analysis Create an ...
Power Query Error Handling How to Deal with Power Query Errors Part 1: • Power Query Error Handling How to D...
✅ Please also check out my Excel course on Udemy, please use this link:
https://www.udemy.com/course/excelfo...