CODEWITHSUNDEEP
databasepowerbifieldrelationship
Heap of Pinto Beans
Heap of Pinto Beans

Reputation: 677

1 to many relationship involving multiple fields in power bi

How do you define 1 to many relationship between two tables in Power BI, when multiple columns are involved.

I.E. Column A, B, and C in table 1 tied to Column E, F, and G in table 2, with a 1 to many relationship.

Upvotes: 0

Views: 640

Answers (1)

Leo - Database Consultant
Leo - Database Consultant

Reputation: 21

You can create a new column concatenating the fields like:

tied01 = CONCATENATE( CONCATENATE(your_dataset[Column A], your_dataset[Column B]), your_dataset[Column C])

And to

tied02 = CONCATENATE( CONCATENATE(your_dataset[Column E], your_dataset[Column F]), your_dataset[Column G])

Once you have these two new columns, you can merge them to only one column or create a dynamic table making the reference for the new created columns

Upvotes: 2

Related Questions