Learn what to pick - Many to Many or Bridge Table - Data Model Decision

[parry2k]

Something from the past but still important and critical for Power BI data models.

Have you ever wondered about the concept of many-to-many relationships in your data model? Are you familiar with the concept of a bridge table? Do you find it challenging to determine when to use one over the other?

In this video, we will explore various data modeling techniques and address the following questions:

Which data model is the most efficient?

What adjustments are necessary for our measures?

When should we modify the cross-filter direction?

How does the chosen model impact our visualizations?

Make sure to hit the subscribe button to stay up to date with the upcoming videos on Power BI and Fabric - youtube.com/@PowerBIHowTo

[v-zhangti]

Hi, @parry2k 

Thanks for sharing!

I find that you are sharing your channel and the PBI videos in the community recently. You could reply yourself to share the links again, and then accept your reply as solution. An answered thread is searched more easily than an open one. Others will learn more from your sharing.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.