2 tables, Unique ID column in Both - Please Help

[NewAndConfused]

Hi,

Apologies but I am new to Power Bi but could really do with some advice please.

I have the following tables:- 

Table 1 - Matrix list of document catagories relating to the different document delivery stages - each item has a unique ID - no duplicates.

Table 2 - List of documents with site location and document delivery stage - multi docs relate to one unique ID from table 1 

I want to be able to create a report that people can filter by site and it will tell them for each stage what documents we have and what documents we are missing.  I cannot seem to link the 2 tables in relationships as it only gives me the option of many to many etc.

Is this possible as I just cannot figure it out.

many thanks Amanda

[Anonymous]

Hi @NewAndConfused ,

I suggest you to create a Dim table and relate this table with both tables to create two one to many relationships.

For reference: Many-to-many relationship guidance - Power BI | Microsoft Learn

If this reply still couldn't help you solve your issue, please share a sample file with me and show me a screenshot with the result you want.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.