Data Model Question for dealing with Multi-Value data columns

[OCMarkW]

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?

TIA

[ryan_mayu]

@OCMarkW 

maybe you can try to split to rows in pq

[OCMarkW]

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,

-or-

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

[ryan_mayu]

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