Model | BI & Reporting

PUGML02 - Working with Driving Tables in Power BI

Wednesday, April 25
14:30 - 15:30
Room: Liffey Hall 2

Level: Yes - C
Level: Intermediate
Presentation Type: Presentation

When creating complex DAX measures in Power BI to enable advanced visualisations, it is often helpful to work with driving tables. A driving table enables many scenarios, like dynamically switching between multiple DAX measures, implementing dynamic relationships, or improving the performance of a model. In this session, we introduce you to the concept of driving tables, and explain how and when to use them individually or together. A driving table enables the use of multiple scenarios in one dashboard as the speaker will shown during a demonstration.

Henk Vlootman

Quanto B.V.

Henk Vlootman is working since 1992 as Excel trainer. In 2010, with the introduction of the self-service tools in Excel, his interest has changed from the die-hard Excel surroundings to the flavors of the Power tools.

Microsoft Power BI, which also uses Power Query and Power Pivot as engine to create reports and dashboards, is now, with Excel, his favorite tool . He is chairman of the Foundation Power BI Gebruikersgroep (Usergroup), The Netherlands. Henk has been an Excel MVP since 2013. In 2016 he was awarded with a double nomination: Excel and Data Platform MVP. In 2017 Henk was awarded Data platform MVP.

Henk presented on several Excel and PowerBI congresses, such as the Dutch Techdays, Excel Experience Day’s, Excel modelling days in Surinam, the ModelOff congress in London, the Bulgarian Excel days in Sofia and several PowerBI meetings in The Netherlands, Germany and Canada.Henk wrote several Excel and Power Pivot books in the Dutch language. His newest book on Power Pivot (with co-author Michiel Rozema) hit the market in 2016.

Henk and Michiel Rozema started in 2018 a new company: Quanto, Collective Analytics. We wants to spread throughout all companies our philosophy: “Quanto works from the vision that everyone in your organization should be able to form their insights. And it is precisely from joint insights that you can continuously improve your organization. We call this Collective Analytics.“


Send Email for Henk Vlootman

Michiel Rozema

Founder & CEO
Quanto B.V.

Michiel Rozema is one of the top Power BI experts in Europe. Working as a Data Insight Lead for Microsoft in The Netherlands for 8 years, he was responsible for the Microsoft Data & Analytics platform, and launched Power Pivot for Excel and Power BI in the country. He is author of two Dutch books on Power Pivot and Power BI modeling (Praktijkboek Power Pivot in Excel, 2013, Pearson/Microsoft Press; Handboek Power Pivot, 2016, Vakmedianet), is founder and board secretary of the Dutch Power BI User Group, and founder and CEO of Quanto.

With a master’s degree in Mathematics and Operations Research, everything related to analyzing data has Michiel’s interest. He has worked in the IT industry for over 22 years in positions in consulting, pre-sales, management, marketing, and business development. One of his qualities is to combine in-depth analytical skills with the ability to have valuable conversations with managers and end-users; always trying to connect stakeholders and looking for pragmatic solutions.

Michiel works in roles like consultant, architect, trainer, and coach for individuals and teams working with Power BI, DAX, SQL Server Analysis Services, and related technologies.


Send Email for Michiel Rozema


Working with Driving Tables in Power BI

Attendees who have favorited this

Send Email for Working with Driving Tables in Power BI