PUGML13 - Don't Be Afraid of the Advanced Editor

Tuesday, April 24
16:00 - 17:00
Liffey Meeting Room 2

Level: Intermediate
Presentation Type: Presentation

There is no reason to be afraid of the advanced editor in Power Query - you can do a lot more in here than the user interface exposes. This session will guide you through different examples of hidden functions and variables you can use in your data extraction and transformations using Power Query, and you will learn how to make your queries dynamic and flexible, and even include error handling, if something you didn't expect to happen actually does. You will leave the session with a good understanding of how powerful the language of Power Query actually is and how you can use it in your tool belt. The learnings can be used both in Power BI Desktop and Excel.

Erik Svensen

CatMan Solution A/S

Microsoft Business Intelligence specialist in a wide variety of business applications. Particularly interested MS Excel, MS-SQL Server, Analysis services and Reporting services.

Leader of Denmark - Power BI User Group.

Now focusing on getting POS data to work as key data in BI solutions enabling my customers to make more effective strategic, tactical and operational insights and decision-making.

Specialties: Excel, OLAP, MDX, Reporting services, PowerPivot, SharePoint, Visualization, Power BI, Power Query, Power Apps, Flow, Azure


Send Email for Erik Svensen


Don't Be Afraid of the Advanced Editor


Attendees who have favorited this

Send Email for Don't Be Afraid of the Advanced Editor