Forum Discussion
Mtaberna
4 years agoFrequent Visitor
split column by "|" NOT in Power Bi Query
Hi, I neet to split this column (1-PATH col) in n columns by a delimitator ( | ) I know this can be easily made with power query but the column is a measure First row result should b...
Mtaberna
4 years agoFrequent Visitor
Hi, thanks for your response.
The thing is that the proposed solutions work for just 2 columns.
I have a max of 9 columns, delimited by this character = |
I need DAX code to split everything inside the column and also consider the case where 1 , 2 or more columns could be empty
New Ideas ?
Thnks
Mtaberna
4 years agoFrequent Visitor
Hi Liu
That worked fine.. in a new table......but is there any other way to create the COLUMNS in the same Original Table ??
The thing is......I need everything in one table
Thanks