Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
sinanalmac
Resolver I
Resolver I

How can create realtionships between three different tables.

Hello All,
I hope everyone doing great. I have an issue with the relationship of the table on PowerBI desktop and I didn't find any information how can I resolve this.
And I have also weak English. I hope I'll explain the situation well.  Sorry for mistakes 


Here is the issue;

I have three different table

Order table, loss table, and YearMaterial table.

Order and Loss Table has values of 2017 and 2018


Material Table has unique material numbers but some material was passed to different categories in 2018. Therefore I had to add year column in this table to separate differences of these materials
I'm trying to do relationships between of these tables. And Of course, PowerBI doesn't allow these relationships because there are no unique values in the material table. Is there any solution or a suggestion to tell me?

 

relationshipsbetweenthree tables.png

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.