Forum Discussion
Limited relationship issue
Related Function always work in the table that is at many side of the relationship . so there should be one to many relationship b/w the tables.
Try creating a Bridge table for storing unique records and then connect that table to both the tables
using one to many relationship.I think that the problem is you have values in both tables which don't appear in the other table, resulting in a blank row being added to both and a many-to-many relationship.
The easiest solution would be to use LOOKUPVALUE rather than RELATED, using your key column to do the lookup.
Sure 🙂
Table 1 contains planned promotions for 3 years in the past. Some articles have been promoted multiple times, so I can't use article id as a key. But those articles have been promoted in different weeks/years, so I merged those two columns into one.
Column 1 (week number / year)
Column 2 (article id)
Column 3 (merged column)
The other table has the same columns and the same merged column.
I tried to connect them (create a relationship), as it suppose to be unique values in Key column (in both tables). But the relationship is not complete, and Related function doesn't work. How, why? What am I doing wrong?
Hi, Salac
Can you provide more example data and what you expect the output to be?
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.