Forum Discussion

Dimadon's avatar
Dimadon
New Member
8 years ago

Merge to Tables

Hi, I need a way to connect two tables. The unique value exists, an order number is used as the identifier. But this number exists several times, so Power BI does not allow it. Can Someone help me here?

 

Thanks a lot!

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    8 years ago
    Dimadon wrote:

    Hi, I need a way to connect two tables. The unique value exists, an order number is used as the identifier. But this number exists several times, so Power BI does not allow it. Can Someone help me here?

     

    Thanks a lot!

    Dimadon

    While the order number exists several times, how can it be unique? For more clarification, could you post any dummy data of those two tables?