Building relationships between tables when both have duplicates
234.1 هزار بار بازدید -
8 سال پیش
-
PowerPivot and Power BI Desktop
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
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
8 سال پیش
در تاریخ 1395/07/28 منتشر شده
است.
234,178
بـار بازدید شده