Forum Discussion
ysherriff
4 years agoResolver II
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
- lbendlinSuper User
You need to use "Split into rows" for such scenarios.
- Ashish_MathurSuper User
Hi,
Share some data and show the expected result.