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.

YOU MAY ALSO LIKE:

Thanks to our sponsors

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

Chris Webb

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

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.

YOU MAY ALSO LIKE:

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