Building relationships between tables when both have duplicates

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=vAvQ8pCnWDk

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: https://curbal.com/donwload-center • SUBSCRIBE to learn more about Power and Excel BI! • / @curbalen • Our PLAYLISTS: • - Join our DAX Fridays! Series: https://goo.gl/FtUWUX • - Power BI dashboards for beginners: https://goo.gl/9YzyDP • - Power BI Tips Tricks: https://goo.gl/H6kUbP • - Power Bi and Google Analytics: https://goo.gl/ZNsY8l • ABOUT CURBAL: • Website: http://www.curbal.com • Contact us: http://www.curbal.com/contact • QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: • ► Twitter: @curbalen, @ruthpozuelo • ► Google +: https://goo.gl/rvIBDP • ► Facebook: https://goo.gl/bME2sB • #SUBSCRIBE #CURBAL • ► Linkedin: https://goo.gl/3VW6Ky

#############################

New on site