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:
- Whole Team Approach to Agile Testing (in London on 5th - 7th June 2017)
- Alberto Brandolini's DDD Modelling Workshop (in London on 26th - 28th June 2017)
- µCon 2017: The Microservices Conference (in London on 6th - 7th November 2017)
- Serverless Architecture with Azure Functions with Christos Matskas! (in London on 29th November 2017)
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/.