An Introduction to Grouping Tables in Power BI: A Bridge Table Too Far

Grouping tables in Power BI is a powerful modeling technique that allows you to select from overlapping groups either in a slicer or across a matrix. Useful for scenarios where say, you have several ad campaigns going on and an individual product can be a part or more than one campaign. Traditional calculated columns or Snowflake tables produce ugly and unpleasant user experiences while grouping tables give end users exactly the behavior they were hoping for. In this video Brian Grant will walk you through what they are and how you can build your own. Since these do usually utilize bi-directional relationships he will also walk you through some things to watch out for when adding these.

Download the companion files 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.