Modeling Multiple Delimited Columns

[ysherriff]

Hi all,

I have a fact table with approximately 30 columns and out of the 30 columns, approximately 6 of the columns needs to be delimited, see image #1, so I can do analysis on the value. I know I can split column in power query by rows , see image #2 but is that the best modeling practice?

What have other users done when they face a situation with multiple columns on the same table that needs to be delimited.?

Thank you and still learning modeling.

Image #1

Image #2

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[lbendlin]

You need to use "Split into rows"  for such scenarios.