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:
- LDNUG September 2017 - #ProgNET Special with Richard Campbell (in London on 12th September 2017)
- Progressive .NET 2017 (in London on 13th - 15th September 2017)
- London Unreal Engine Meetup (in London on 20th September 2017)
- Test Driven Development (TDD) Workshop with Damjan Vujnovic (in London on 7th - 8th December 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/.