Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Data Model Question for dealing with Multi-Value data columns

Data Model Question for dealing with many Multi-Value data columns.       Each data column has multiple values with ";" seperators.   


Should I unroll the different columns values into their own tables with a relationship key back to the one original Dim record?   In other words create a star schema.


Or leave them and use Measures with SEARCH / SUBSTITUTE functions to select the Dim records?     


Which is easier to visualize?


Super User
Super User


maybe you can try to split to rows in pq


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Thanks.    I know how to split and manipulate the data into various tables.      I have no problems with Power Query / M and DAX measures.    


My question is still from a design standpoint, should I create the different tables and link them back to the original row,




just leave the semicolon values alone and use a SEARCH measure to to get the row?

i think you duplicate the column and the new column after splitting can still link back to the original column

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors