Answering questions: another option for many to many relationships in Power BI - Unplugged #39

233Likes

10,377Views

2021Dec 18

Analyze and measure the performance of an alternative data modeling solution suggested by Daniel Otykier (author of Tabular Editor) regarding the article Different options to model many-to-many relationships in Power BI and Tabular (https://www.sqlbi.com/articles/differ.... Which solution is faster? Or "it depends"? Watch the video to see the answer! Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Answering questions: another option for many to many relationships in Power BI - Unplugged #39

Key moments View all

New Way of Modeling Many-to-Many Relationships

New Way of Modeling Many-to-Many Relationships

New Way of Modeling Many-to-Many Relationships

What Happens When both Filters Are Working at the Same Time

What Happens When both Filters Are Working at the Same Time

What Happens When both Filters Are Working at the Same Time

What Happens if We Apply a Filter from Customer and Sport at the Same Time

What Happens if We Apply a Filter from Customer and Sport at the Same Time

What Happens if We Apply a Filter from Customer and Sport at the Same Time

Conclusions

Conclusions

Conclusions

SQLBI

Answering questions: another option for many to many relationships in Power BI - Unplugged #39

Comments 18

Key moments

New Way of Modeling Many-to-Many Relationships

New Way of Modeling Many-to-Many Relationships

New Way of Modeling Many-to-Many Relationships

What Happens When both Filters Are Working at the Same Time

What Happens When both Filters Are Working at the Same Time

What Happens When both Filters Are Working at the Same Time

What Happens if We Apply a Filter from Customer and Sport at the Same Time

What Happens if We Apply a Filter from Customer and Sport at the Same Time

What Happens if We Apply a Filter from Customer and Sport at the Same Time

Conclusions

Conclusions

Conclusions

Description

Key moments View all

New Way of Modeling Many-to-Many Relationships

New Way of Modeling Many-to-Many Relationships

New Way of Modeling Many-to-Many Relationships

What Happens When both Filters Are Working at the Same Time

What Happens When both Filters Are Working at the Same Time

What Happens When both Filters Are Working at the Same Time

What Happens if We Apply a Filter from Customer and Sport at the Same Time

What Happens if We Apply a Filter from Customer and Sport at the Same Time

What Happens if We Apply a Filter from Customer and Sport at the Same Time

Conclusions

Conclusions

Conclusions

SQLBI

Transcript

Different options to model many to many relationships in Power BI and Tabular

Key moments

Key moments