Forum Discussion

OCMarkW's avatar
OCMarkW
Frequent Visitor
3 years ago

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

General Comment
Need Help

3 Replies

    • OCMarkW's avatar
      OCMarkW
      Frequent Visitor
      3 years ago

      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's avatar
        ryan_mayu
        Super User
        3 years ago

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