Parameters are one of the most useful features in Power Query/Excel and Power BI, and in this session you'll find out how you can use them to make your queries easier to maintain and more user-friendly. In addition you'll also learn how you can use parameters to create Power BI template files, and also how they can be used to create M custom functions (without writing any code!) which in turn can be used to create complex data transformations.
Working with Parameters and Functions in Power Query/Excel and Power BI
Chris Webb is an independent consultant specializing in Analysis Services, Power Pivot, Power BI, DAX and MDX. He is a co-author a few books on cube development and the Microsoft BI tools and is writing a book on PowerQuery. He blogs about Microsoft BI at http://cwebbbi.wordpress.com/.