MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship
Download files for videos: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/MSPTDA-27-28-DownloadAllFiles.zip
Class web site with individual file downloads: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/DataModeling.htm
pdf notes for Video: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/027-28-MSPTDA-ManyToMany.pdf
In this video learn about how to create a Bridge Table for a Many-To-Many Relationship using Power Query in either Power BI or Excel Power Pivot. Learn three methods for a Bridge Table: B-Directional Filetrs, CROSSFILTER DAX Function or a Table Filter.
Topics:
1. (00:23) Introduction & look at Data Modeling Problem
2. (01:00) Fundamental Problem with a Many-To-Many Relationship
3. (02:05) What is a Many-To-Many Relationship?
4. (03:25) Start to create Reports and discover the Problem with a Many-To-Many Relationship.
5. (04:52) Build Bridge Table using Excel Power Query
6. (07:32) First look at underlying filtering for a Many-To-Many Relationships
7. (08:36) Three Options with a Bridge Table.
8. (09:02) Build Bridge Table using Power BI Desktop Power Query
9. (10:25) Bi-Directional Filter
10. (10:53) Visual Animation to illustrate how Many-To-Many Relationship works with a Bridge Table.
11. (11:39) Ambiguity in Model with Bi-Directional Filters.
12. (12:19) CROSSFILTER DAX Function example
13. (13:41) Table Filter Example
14. (14:05) Expanded Diagram to “see” how Table Filter works with a Bridge Table and a Many-To-Many Relationships
15. (15:08) Difference between Grand Total Cell formulas for CROSSFILTER and Table Filter
16. (16:10) Cross Tab Report
17. (16:53) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Видео MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship канала ExcelIsFun
Class web site with individual file downloads: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/DataModeling.htm
pdf notes for Video: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/027-28-MSPTDA-ManyToMany.pdf
In this video learn about how to create a Bridge Table for a Many-To-Many Relationship using Power Query in either Power BI or Excel Power Pivot. Learn three methods for a Bridge Table: B-Directional Filetrs, CROSSFILTER DAX Function or a Table Filter.
Topics:
1. (00:23) Introduction & look at Data Modeling Problem
2. (01:00) Fundamental Problem with a Many-To-Many Relationship
3. (02:05) What is a Many-To-Many Relationship?
4. (03:25) Start to create Reports and discover the Problem with a Many-To-Many Relationship.
5. (04:52) Build Bridge Table using Excel Power Query
6. (07:32) First look at underlying filtering for a Many-To-Many Relationships
7. (08:36) Three Options with a Bridge Table.
8. (09:02) Build Bridge Table using Power BI Desktop Power Query
9. (10:25) Bi-Directional Filter
10. (10:53) Visual Animation to illustrate how Many-To-Many Relationship works with a Bridge Table.
11. (11:39) Ambiguity in Model with Bi-Directional Filters.
12. (12:19) CROSSFILTER DAX Function example
13. (13:41) Table Filter Example
14. (14:05) Expanded Diagram to “see” how Table Filter works with a Bridge Table and a Many-To-Many Relationships
15. (15:08) Difference between Grand Total Cell formulas for CROSSFILTER and Table Filter
16. (16:10) Cross Tab Report
17. (16:53) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Видео MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing](https://i.ytimg.com/vi/nBu1Bqa1jjs/default.jpg)
![Manage Many to Many Relationships in Power Pivot](https://i.ytimg.com/vi/c-s5nXMfbk8/default.jpg)
![#41 Understanding relationships in Power BI Desktop](https://i.ytimg.com/vi/-4ybWQSRcOY/default.jpg)
![Is MANY TO MANY, too many? | Power BI many to many relationships explained](https://i.ytimg.com/vi/NdrrjkvH2zo/default.jpg)
![](https://i.ytimg.com/vi/09ETeBtWcgk/default.jpg)
![MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships](https://i.ytimg.com/vi/D-lhoXK6WIg/default.jpg)
![Power BI Relationship: Many to Many & Bi-Directional Filtering #Q&A](https://i.ytimg.com/vi/93VENTlfXi0/default.jpg)
![MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas](https://i.ytimg.com/vi/sVdUqF9QYhc/default.jpg)
![MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table](https://i.ytimg.com/vi/Q5ATZdAihl4/default.jpg)
![Looking at Power BI Many to Many](https://i.ytimg.com/vi/ZrANsDNnZug/default.jpg)
![MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report](https://i.ytimg.com/vi/uEgFzdx-bhE/default.jpg)
![Different types of many to many relationships in Power BI](https://i.ytimg.com/vi/0wDG3chIbiw/default.jpg)
![Create a Many to Many Relationship Model in Power Pivot](https://i.ytimg.com/vi/4dGtJUc_jeU/default.jpg)
![Handling MULTIPLE fact tables in Power BI](https://i.ytimg.com/vi/TnyRsO4NJPc/default.jpg)
![MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set](https://i.ytimg.com/vi/rSQwZ1d3b1g/default.jpg)
![Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)](https://i.ytimg.com/vi/yFxjkaXKjPM/default.jpg)
![Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554](https://i.ytimg.com/vi/4yCdOfvmJWc/default.jpg)
![Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)](https://i.ytimg.com/vi/ohGFPF12Qwc/default.jpg)
![How to easily automate boring Excel tasks with Power Query!](https://i.ytimg.com/vi/L4BuUzccLpo/default.jpg)
![How To Break Out Large Tables Into Multiple Tables And Build A Model - Power BI Tips](https://i.ytimg.com/vi/DhFrwNQw3BM/default.jpg)