cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ev2412 Frequent Visitor
Frequent Visitor

Split columns by multiple Delimiters and create multiple rows in DAX

Hey,

 

I am trying to split 3 columns by delimiter.  How can I create 2 rows with the new info after the & delimiter without duplicating everything 6 times?

 

My data looks like this

 

Installed model                         Capacity                    Category

Unit A & Unit B                       5.00 & 2.50                      2 & 1

 

Should look like

Unit A                                    5.00                                    2

Unit B                                      2.5                                    1

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Split columns by multiple Delimiters and create multiple rows in DAX

@ev2412 

 

please see the attached file's Query Editor for clarity

 

2 REPLIES 2
Super User
Super User

Re: Split columns by multiple Delimiters and create multiple rows in DAX

@ev2412 

 

You can add a new custom column as follows. Then expand it to new rows

 

=Table.FromColumns({
     Text.Split([Installed model],"&"),
     Text.Split([Capacity],"&"),
     Text.Split([Capacity],"&")},

Table.ColumnNames(Source))

 

 

 

Super User
Super User

Re: Split columns by multiple Delimiters and create multiple rows in DAX

@ev2412 

 

please see the attached file's Query Editor for clarity