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:
- Introduction To Dataflows In Power BI (SkillsCast recorded in May 2019)
- Lightbend Scala Language - Professional (in London on 10th - 11th December 2019)
- PowerBI Must Know Speed Up Tricks (SkillsCast recorded in October 2019)
- The Power Query Editor and How to Use it to Improve Your Power BI Reports. (SkillsCast recorded in September 2019)
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