Presentation Type: Presentation
Parameters are an extremely useful feature of the Power BI Query Editor. In this session you'll learn how they can be used to switch your queries from using one data source to another, how they can be used to control filtering and other transformations, and how they can be used with templates to make it easy for other users to create new Power BI reports. You'll also see how they can be used to create functions without writing any M code, and how these functions can in turn be used to apply the same filters and transformations across multiple data sources.
Crossjoin Consulting Limited
Chris Webb is a UK-based consultant and trainer specialising in Power BI and SQL Server Analysis Services. He is a frequent presenter and conferences and user groups all over the world including the PASS Summit, SQLBits and SQL Saturdays, and has written or co-written several books and white papers including "Power Query for Power BI and Excel" and the Microsoft white paper "Planning a Power BI Enterprise Deployment". He blogs about Microsoft BI at https://blog.crossjoin.co.uk/
Tuesday, April 24
5:30 PM – 6:30 PM
Wednesday, April 25
9:00 AM – 10:00 AM