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 ...
General Comment
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

OCMarkW 

maybe you can try to split to rows in pq

  • 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