Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
OCMarkW
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?

TIA

3 REPLIES 3
ryan_mayu
Super User
Super User

@OCMarkW 

maybe you can try to split to rows in pq

1.PNG2.PNG





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,

 

-or-

 

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

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.