Forum Discussion

ysherriff's avatar
ysherriff
Resolver II
4 years ago

Modeling Multiple Delimited Columns

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

 

 

2 Replies