Untangling Nested Headers in Power Query

KIRILL PERIAN (Pragmatic Works) – Untangling Nested Headers in Power Query

We have all seen those pivot tables with multiple headers that make us pause, scratch out heads and wonder how in the world are we going to consume such a monster into our data model. In a short 30-minute session we will go through a couple of use cases step by step and create a perfect (and repeatable) query to create a fact table for your Power BI data model.

Kirill Perian is an MCSA in BI Reporting and a Senior Consultant at Pragmatic Works. He is a huge fan of data analytics, always looking to learn new things in the field of business intelligence, data governance and visualization best practices. Kirill enjoys solving data problems and being part of data community, both on local and global scale.

Download Kirill’s training content: click here

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.