Create a Many to Many Relationship Model in Power Pivot
If you're familiar with Power Pivot, you probably know that you can't create many-to-many relationships between multiple tables. But in real life there may be instances where we would want to manage many to many relationship to help answer some questions. This video give an example of a type of question that begs to be answer and uses Power Pivot and some DAX functions to help answer this question. Hint: It involves the use of a bridge table.
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF File to Excel
~-~~-~~~-~~-~
Watch video Create a Many to Many Relationship Model in Power Pivot online without registration, duration hours minute second in high quality. This video was added by user Doug H 21 August 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 80,935 once and liked it 1.2 thousand people.