Hx9vx9qqbuijl41vmisf
SkillsCast

Working with Parameters and Functions in Power Query/Excel and Power BI

18th May 2017 in London at CodeNode

This SkillsCast was filmed at Working with Parameters and Functions in Power Query/Excel and Power BI

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.

Thanks to our sponsors

Working with Parameters and Functions in Power Query/Excel and Power BI

Chris Webb

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/.

SkillsCast

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.

Thanks to our sponsors

About the Speaker

Working with Parameters and Functions in Power Query/Excel and Power BI

Chris Webb

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/.