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.
YOU MAY ALSO LIKE:
Working with Parameters and Functions in Power Query/Excel and Power BI
Chris Webb is an independent consultant specialising in Analysis Services, Power BI, M, MDX and DAX. He is the author of "Power Query for Power BI and Excel" and a co-author of "SQL Server Analysis Services 2012: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase"; he also co-authored the white paper "Planning a Power BI Enterprise Deployment" for Microsoft. He blogs at http://blog.crossjoin.co.uk