Table field with more than one record

[Syndicate_Admin]

Hello

Is it possible to create a table where there is a field where you can put two records?

Basically, I want what you see in capture since I want to create a filter later.

For example, zone 3 ALMERIA belongs to delegacion valencia and rep1019. In the filter I want both valence and 1019 separately and that the areas that belong to them appear.

Thank you.

[Syndicate_Admin]

There @apenaranda ,

Please check my answer to your topic in this link: https://community.powerbi.com/t5/Desktop/Table-field-with-more-than-one-record/m-p/3173214#M1070702

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

Thanks
Best regards,
Joao Ribeiro

[joaoribeiro · Accepted solution]

Hi @Syndicate_Admin ,

In Power Query, you can create a table to relate zone to each delegacion. For that, you can create a "reference" to the original table, and then follow the steps below:

1. Create a reference:

2. Split Columns By Delimiter (in you case I believe its comma):

3. Select all columns that are not the "splitted" delegaciones and select tranform > Unpivot Columns > Unpivot Other Columns:

4. You can TRIM the text to remove leading spaces:

5. Remove the 'Attribute' column, and then you have all delegaciones in rows to use for filtering. For that, you just need to create a relationship to your original table (consider using bridge tables to avoid many-to-many relationships).

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

Thanks!
Best regards,
Joao Ribeiro

[Syndicate_Admin]

It worked perfectly. Thank you.

[Syndicate_Admin]

Hi @apenaranda would you be so kind as to mark my answer as a solution as well? As Syndicate Admin only replicated it here in Spanish. Thanks a lot!