Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

SUMMARIZING TABLES

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!

General Comment
Need Help
Tips and Tricks

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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
    )