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 he...
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?