Split columns by multiple Delimiters and create multiple rows in DAX

Question

Hey,&nbsp;I am trying to split 3 columns by delimiter.&nbsp; How can I create 2 rows with the new info after the &amp; delimiter without duplicating everything 6 times?&nbsp;My data looks like this&nbsp;Installed model&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Capacity&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CategoryUnit A &amp; Unit B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5.00 &amp; 2.50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &amp; 1&nbsp;Should look likeUnit A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2Unit B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1

zubair_muhammad · Accepted Answer

Anonymous&nbsp;
&nbsp;
please see the attached file's Query Editor for clarity
&nbsp;

Forum Discussion

Split columns by multiple Delimiters and create multiple rows in DAX

2 Replies

Related content

MULTIPLE CARD

Multiple dataViewMappings

PowerQuery - Text before multiple Delimiters

extract text using Multiple delimiters

Disable multiple eventstreams