Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |