PowerPivot and Power BI Desktop only allow the creation of relationships between tables when one of columns forming the relationship does not have duplicate values.
In order to relate these two tables to one another, what we need is a third table with all distinct values from both tables. In this tutorial we will show you how to do just that.
Link to Power BI file used in the video, get file #41 on the community downloads folder: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
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: curbal.com
Contact us: curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#SUBSCRIBE #CURBAL
► Linkedin: goo.gl/3VW6Ky
- Building relationships between tables when both have duplicates ( Download)
- Building Relationships with Duplicate Values | Power BI for beginners ( Download)
- Manage Many to Many Relationships in Power Pivot ( Download)
- Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in Excel ( Download)
- DAX CALCULATE Trick to Pass Filters from Many to One Side of Relationship ( Download)
- Handling MULTIPLE fact tables in Power BI ( Download)
- 2 Rules to Build a One to Many Relationship in Power BI #shorts ( Download)
- Using Power Query to Combine Multiple Tables and Remove Duplicates | Everyday Office ( Download)
- How to manage Many-To-Many relationships in a Data Model |Data Modeling Tutorial |BI Consulting Pro ( Download)
- Solve Many to Many Joins Using Bridge Tables - Monkey Shorts Episode 038 ( Download)
- Handling Many to many relationship issue in Power BI | Power BI for Beginners ( Download)
- Create a Many to Many Relationship Model in Power Pivot ( Download)
- Power BI Tutorial: Create Relationships Between Tables in Power BI ( Download)
- Using Power Pivot Relationships for Pivot Tables | Everyday Office ( Download)
- Understanding Relationships in Power BI // Beginners Guide to Power BI in 2021 ( Download)
