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/training.html
📚 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"
https://www.youtube.com/watch?v=COUOvhbQ4CQ
-~-~~-~~~-~~-~-
Видео Create a Many to Many Relationship Model in Power Pivot канала Doug H
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html
📚 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"
https://www.youtube.com/watch?v=COUOvhbQ4CQ
-~-~~-~~~-~~-~-
Видео Create a Many to Many Relationship Model in Power Pivot канала Doug H
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Pivot One Column Address - Excel #ShortsCreate an Org Chart in Visio Using Manual StepsCreate a Dynamic Calendar TableUse PowerQuery to Change the Order of Cell Values or TextPerform Basic Correlation Analysis in ExcelUnveiling the Hidden Power of the TEXT Function for Currency ConversionHow to Copy Formatting from Cells or Charts in Excel: A Step-by-Step GuideCreate a Moving Average [2 Examples]Use a Picture in a ChartPerform a One Sample Proportion Test in ExcelUse the Excel Geography Data Type & Filled Map FeatureSort Columns or RowsCreate a SlopegraphKeyword Lookup with Power QuerySeparate Username from Email - Excel #ShortsUse the Forecast Sheet in ExcelCreate Video Inside Text or a Track Matte EffectDependent Drop Down List Dynamic Array in ExcelExcel Secrets: Remove Duplicates in Seconds - Excel #ShortsFinding Duplicate Values - Google SheetsExtract Hyperlinks from Sentences in a Column