SUMMARIZING TABLES

[Anonymous]

Hello, 

I have some knowledge in PBI, but dont know how to do the following:

Got 4 tables, with relationships within each others, 

This is just an example, 

I need to create just one table which sow me the ORDER ID, DELIVERY HOUR, TRANSPORT ID, CLIENT, AND DELIVERY DAY, with no duplicate values

Please I will appreciate if someone could help me please!

[Phil_Seamark]

Hi @Anonymous

Without seeing the actual relatoinships,  what happens if you try a calculated table using the following code

New Table = ALL(
    'Table1'[Order ID] ,
    'Table2'[Delivery Hour] ,
    'Table3'[Transport ID] ,
    .... etc
    )