Solved: New rows from columns

Anonymous · ‎10-27-2021

Hi folks,

I'm trying to create new rows from columns. Eg.:

From this:

To this:

Any help?

Anonymous · ‎11-01-2021

Hi @Anonymous ,

Please try:

New Table = 
var _t1=SELECTCOLUMNS('Table',"Name",[Column1],"Start",[Column2],"End",[Column3])
var _t2=SELECTCOLUMNS('Table',"Name",[Column1],"Start",[Column4],"End",[Column5])
return FILTER( DISTINCT( UNION(_t1,_t2)) ,[Start]<>BLANK() && [End]<>BLANK())

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous · ‎11-01-2021

Hi @Anonymous ,

Please try:

New Table = 
var _t1=SELECTCOLUMNS('Table',"Name",[Column1],"Start",[Column2],"End",[Column3])
var _t2=SELECTCOLUMNS('Table',"Name",[Column1],"Start",[Column4],"End",[Column5])
return FILTER( DISTINCT( UNION(_t1,_t2)) ,[Start]<>BLANK() && [End]<>BLANK())

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

TheoC · ‎10-28-2021

Hi @Anonymous

If you go into Power Query, you can select all columns you want to unpivot. Right click on the header of one and click Unpivot Columns.

Hopefully gets you the results you're after.

All the best.

Theo

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias