Split columns by multiple Delimiters and create multiple rows in DAX

[Anonymous]

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

[Zubair_Muhammad · Accepted solution]

@Anonymous 

please see the attached file's Query Editor for clarity

[Zubair_Muhammad]

@Anonymous 

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))