User Profile
OCMarkW
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
Re: Data Model Question for dealing with Multi-Value data columns
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?752Views0likes1CommentData 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? TIA816Views1like3Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.