Adding data from column from unrelated table

Hi DanielB_NL 

One workaround is that creating a bridge table,

1. extract the purchase_receipt_nr and article_code from both the tables

2. append these 2 new tables add a new column to concatenate 2 columns, and remove duplicates --> now this is a dimension table with 3 columns (purchase_receipt_nr, article_code & concatenate of these 2)

3. do the concatenate in both the detailed tables

4. make the relationship from the dimension table to both the detailed tables with concatenate column

5. take the purchase_receipt_nr and article_code from the dimension and others as regular measures...

hope this will help.. 

Thanks & Regards,

Mohammed Adnan

Learn Power BI: https://www.youtube.com/c/taik18

Hi mohammedadnant,

It was a step in the right direction.  In the end it ended up in a many-to-many relation. I used your suggestion to create a dimension table, but added the sequence no. column to this table, created the concatenated column based on purchase_receipt_nr and article_code and removed duplicates based on the concatenated column. In practice, the chance that on one Purchase Receipt No. there are more of the same Article is very small, so the 'damage' done by removing the duplicates is close to zero.