Is MANY TO MANY, too many? | Power BI many to many relationships explained

No video

Is MANY TO MANY, too many? | Power BI many to many relationships explained

Рет қаралды 44,033

Күн бұрын

In this video we are going to go through Power BI Many to many relationships that were realeased in the POwer BI desktop July 2018 update.
This is what we will cover:
1. What are Many to many relationships
2. Why you should avoid them
3. How to avoid them
Questions, comments? Let me know in the comment box!
Links to related videos:
Composite models: • COMPOSITE MODELS EXPLA...
About Power bI relationships:
Many2many: • Building relationships...
Relationships: • #41 Understanding rela...
Wrong totals:
• DAX Fridays! #25: Wron...
Looking for a download file? Go to our Download Center: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Linkedin: goo.gl/3VW6Ky
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#SUBSCRIBE #CURBAL
#POWERWEEK #CURBAL #POWERBI #POWERBIUPDATE #MVP

Пікірлер: 106

@juanlopez4033 3 жыл бұрын

You know, you are really smart. I appreciate your instructor style. Not that you are trying to avoid M-to-N relationship, but more to understand the way of today's columnar horizontal BI tools behave with data. The essence is most of us are two-dimensional thinkers trying to make sense of cube-dimensional thinking. We can understand 2x2 = 4, but when it comes to understanding 2 to 8th power, we run into possible 256 combinations our mind cannot right away visualize. In database modeling, what you've explained is resolution via Ternary key associating two M-to-N tables, where it is impossible to apply a binary key to the many-to-many relationship tables. Again, thank you for your help. Stay safe. :)

@CurbalEN 3 жыл бұрын

And thanks for your explanation and feedback 😊

@Phoenixspin 5 жыл бұрын

I had many relationships many times. My girlfriend didn't like it. Now I just have one relationship with her. Stay away from many-to-many relationships like the plague. Good advice.

@CurbalEN 5 жыл бұрын

😂😂😂 true! Like life itself ! /Ruth

@sumantjoshi490 2 жыл бұрын

I have seen multiple many to many relationship videos on KZfaq but this was the best one. Thanks and Keep up the good work Ruth 👍

@CurbalEN 2 жыл бұрын

Thank you!

@angelobarroso5912 2 жыл бұрын

I just find your youtube videos. I think you´re great. Awesome explanations. I've subscribed your channel. Keep going. congratulations!

@CurbalEN 2 жыл бұрын

Welcome!! ;)

@jaguarprovo 2 жыл бұрын

Ruth you’re a life saver.

@CurbalEN 2 жыл бұрын

Thank you!

@EyiBillion Жыл бұрын

Brilliant! Great Job. This solved a puzzle struggling with for a long time.

@CurbalEN Жыл бұрын

Music to my ears!!! 😃

@josepromero1452 6 жыл бұрын

Exact! Ruth. The best advise is: DO NOT USE M2M RELATIONSHIPS and use traditional method. I tried (as you) when it was released and immediately forgot it. Really good and practise video! Josep.

@CurbalEN 6 жыл бұрын

Thanks!! Those that are more familiar with M2M can probably use it , but for the rest of us mortals... best to stay away! /Ruth

@juja2819 6 ай бұрын

Thank you for the explanation! Would like to see a measure multiplying two columns from each table in examples with bridge tables, for instance at 11:13, Amount and StockNo. Is this possible?

@eladiobardelli3001 6 жыл бұрын

Ruth podrías hacer un día de estos , un vídeo sobre el proyecto que mas te ha gustado de Power Bi que hayas efectuado y explicando detalles hechos y retos que tuviste en el camino desde el punto de vista objetivos y desafíos Dax.

@CurbalEN 6 жыл бұрын

Los proyectos en los que trabajo son confidenciales, tendría que preguntar a mis clientes. Has visto los vídeos de la FIFA? Los hice en vivo y en directo casi... /Ruth

@joanneosborne2428 4 жыл бұрын

Thanks, Ruth. This was very informative and I love the way you explained it. Have a great day and please stay safe and healthy.❤

@ShabnamKhan-vk7fj 4 жыл бұрын

Thanks so much for Ruth, you are so kind to share your insights and experience with us. As always, I found it super useful. Please keep up the good work!

@CurbalEN 4 жыл бұрын

Yey!! 🎉🎉 /Ruth

@lisbongraffiti242 Жыл бұрын

When you add this kind of tables for a many-many relationships it can be considered a star model or is a different kind?Thank you

@xiomaragotch9453 3 жыл бұрын

this solved the issue that I was experiencing. Thanks so much!!!!!!!!!!!!!!

@CurbalEN 3 жыл бұрын

Delighted to hear that!

@Lena2012102 6 жыл бұрын

Great video! It will be nice to hear also, how to prepare formulas for BASKET analysis. If you need to understand how many and wich products were bought, when one specific purchased.

@CurbalEN 6 жыл бұрын

Oh yes! I did that for a customer a while ago, I can prepare a video in the future. /Ruth

@Nicky411 5 жыл бұрын

Thank you sooooooo much! I'm used to Informatica, and it is really hard to get used to PowerBI.

@CurbalEN 5 жыл бұрын

Push through! The rewards are behind the corner ;) /Ruth

@Wzxxx Жыл бұрын

But why it should consider ie. product filter when being connected by date ? What do You mean by ignoring? If it was "normal" relation it would be the same. You do not use any filter on dates (in both tables at the same time tables as there is no date table which connects both)

@thihaihahoang4609 4 жыл бұрын

Great vid! Tks so much for sharing this. However after registered for member, I was trying to join the community and download sources but I couldn't. How can I contact for help please? Much appreciated! 🙂

@CurbalEN 4 жыл бұрын

Send me an email here: Curbal.com/contact And I will get back to you tomorrow. /Ruth

@laprasdewgong5022 4 жыл бұрын

Great video as always. Easy to understand. Thank you very much Ruth!

@CurbalEN 4 жыл бұрын

Yey!! 😃 /Ruth

@kristinamelnichenko5775 3 жыл бұрын

Very good thank you

@fsdanything9116 5 жыл бұрын

Hi - I know this is only partly related, but have you found a way of managing the tables in the relationship view so that they stay where you put them ? I have re-arranged my tables sooo many times now

@CurbalEN 5 жыл бұрын

You mean the relationships or the actual tables? /Ruth

@SpacePoodle 5 жыл бұрын

Great vid!! Thanks for sharing your skills :)

@CurbalEN 5 жыл бұрын

And thanks to you for watching!! :) /Ruth

@sandipansarkar9211 8 ай бұрын

FINISHED WATCHING

@CurbalEN 8 ай бұрын

👏

@indunildayawansa5087 4 жыл бұрын

Hi Ruth, if I have same values in multiple columns how do I make a relationship? Table has Employee number, Equip1, Equip2, Equip3, Equip4 upto 10 items and their model, Serial etc. Equip1 have computer, Laptop, Monitor, Keyboard etc. and same data in Equip 2, 3, 4. So if I want to know how many laptops, desktops etc for each employee, how do I make relationship?

@jaimemejia4387 4 жыл бұрын

Gran explicación, muchas gracias. Tus videos han sido de gran ayuda para aprender Power Bi, Dax y el modelado de datos.

@CurbalEN 4 жыл бұрын

Un placer! /Ruth

@toygraphers240 2 жыл бұрын

Thank you very much

@indrewhite 3 жыл бұрын

Love your channel and advice on power BI!

@CurbalEN 3 жыл бұрын

Thanks Indre!

@luisjavier1284 5 жыл бұрын

I really impressive. I like the way that you usted to explanó the things. You clarified me how relationships work. Thanks you. I subscribed to to your Channel

@CurbalEN 5 жыл бұрын

Welcome to the channel y Saludos! :) /Ruth

@nikhilagarwal9689 2 жыл бұрын

Great video..helped me to resolve the issue. Thanks for sharing 😊

@CurbalEN 2 жыл бұрын

My pleasure!

@tanababa 6 жыл бұрын

Thank you Ruth, great video

@CurbalEN 6 жыл бұрын

Phew! Glad it was useful ! :) /Ruth

@frankgovers8420 6 жыл бұрын

Great Ruth, but what if there are products in the budget table and not in sales. Now the product filter does not work. So filtertable product must have values from both tables, without duplicates

@CurbalEN 6 жыл бұрын

I didn’t mean that this is the master way to solve this, I just pointed it as one solution, hope that was clear! That is the trickiest thing about DAX, no formula or model fits all! The point of the video is explaining the many to many relationships:) /Ruth

@frankgovers8420 6 жыл бұрын

Curbal youre right, but I am always analysing the problems

@CurbalEN 6 жыл бұрын

No worries, you are right too ;) /Ruth

@jasonwoodward5501 4 жыл бұрын

Happy Christmas and thanks again

@CurbalEN 4 жыл бұрын

Merry Xmas!! /Ruth

@amantin 5 жыл бұрын

This is a GEM 💎!! Thank you!

@CurbalEN 5 жыл бұрын

Wonderful! And thanks for the feedback ;) /Ruth

@user-gy7uu9gt8n 2 жыл бұрын

Why the relationship direction is single for calendar and product at the end not both? Or it doesn't matter.

@user-gy7uu9gt8n 2 жыл бұрын

Oh it will cause a cycle!

@edsta714 6 жыл бұрын

Sometimes I have a lot of columns that would require over 20 bridge tables for example. I’ve gotten around it by making a concatenated column to make it unique 1 to 1. Just wondering if you recommend any other methods? Thank you. Your videos are always educational.

@CurbalEN 6 жыл бұрын

Creating unique keys is a great way to get around the problem. Depending on the model, I would probably do the same :) /Ruth

@srinivaskandru5034 5 жыл бұрын

Everything is awesome...but please change the image after 0:55 for subscription call...it is not good..heheehhe. You are looking good in that image..it is lifeless...But definitely I got the point you explained in this video.

@CurbalEN 5 жыл бұрын

Hahahaha it is meant to be “bad” , but I didn’t know it was that disturbing! I will change it as soon as I can! /Ruth

@srinivaskandru5034 5 жыл бұрын

Frankly speaking, it reminds me a cancer patient who has just returned from hospital after a chemotherapy treatment..loosing all the hair over head...sorry....pleeeease change it immediately....

@CurbalEN 5 жыл бұрын

😂😂 is not that bad!! /Ruth

@tabish.k.ansari 4 жыл бұрын

Thanks

@xuantungnguyen9719 3 жыл бұрын

the food example seems like a one:one relationship with composite key is date+food_name. Feel free to correct me if I'm wrong.

@nguyendaominh1078 2 жыл бұрын

There are duplicates in both "Date" & "Product name" in both tables, so how come it's a one:one relationship?

@pulkitverma1105 3 жыл бұрын

Great Video. Thanks

@neelamzaidi1683 2 жыл бұрын

I LOVE YOU!!!!

@maheshpulli1663 4 жыл бұрын

Thank you very much.

@MohammedAliOmairi Жыл бұрын

thanks

@kebincui 3 жыл бұрын

Thank you Ruth👍

@CurbalEN 3 жыл бұрын

My pleasure!

@Ahmad_Askar 6 жыл бұрын

can i ask which whiteboard tool you are using? great video by the way i am always a fan of a bridge table

@CurbalEN 6 жыл бұрын

Hi! Epic Pen, great tool and Thanks! /Ruth

@Ahmad_Askar 6 жыл бұрын

Thanks a ton

@jasonwoodward5501 4 жыл бұрын

Thanks Ruth

@VigilanteHD 4 жыл бұрын

Much appreciate this!

@marwatkinson 5 жыл бұрын

Hi in your solution, did you put the table like in 6:31" ? Because I can't really see how that will be solved

@CurbalEN 5 жыл бұрын

Not sure what you mean with "put the table" /Ruth

@rahulkallur5789 3 жыл бұрын

Really impressive.Can we have relationship between tables using multiple columns

@CurbalEN 3 жыл бұрын

No, check this video for how to do that: m.kzfaq.info/get/bejne/l7yTe6aXtKfYinU.html

@rassten 6 жыл бұрын

So the main point can be boiled down to: many to many = bad; and bridge table = good

@CurbalEN 6 жыл бұрын

Oh my Lord! ...and it took me 17 min to say that...You are hired! /Ruth

@rassten 6 жыл бұрын

I have actually worked in Sweden today, but only in Lund.

@CurbalEN 6 жыл бұрын

Oh! Next time take the train 🚊 up ;) Would be great to meet you ! /Ruth

@DanielWeikert 5 жыл бұрын

Most of the time I hear many to many is dangerous because of potential ambiguity in the model. Could you elaborate on different scenarios when they really make sense? Thank you. Great video

@CurbalEN 5 жыл бұрын

Sqlbi has a few, check them out if this one didn’t help. /Ruth

@DanielWeikert 5 жыл бұрын

@@CurbalEN Thanks Ruth, yes I already checked them but still looking for more. It's a quite interesting topic. Best regards

@CurbalEN 5 жыл бұрын

I agree! As I stay away from M2M I don’t have good cases to showcase. Have you tried asking in the power bi community? /Ruth

@DanielWeikert 5 жыл бұрын

@@CurbalEN good idea. Just prefer video over description. ;) Visual learner