Forum Discussion
Multiple lines into columns
Dears,
I have a table with multiple status lines and timestamps, what I'm trying to do is to move the timestamps into columns as in the following example:
How can I replicate this result in PowerBI?
Thank you for your support!!
T
Hi Anonymous
You can use the pivot/unpivot feature in the query editor. Check this out:
http://radacad.com/pivot-and-unpivot-with-power-bi
Hi Anonymous ,
you can do that with Pivot Column in the Power Query Editor.
You select the column Status and click on Pivot Column and than you chose the column Date as you can see on the screenshot below. The screenshot shows the result.
2 Replies
Hi Anonymous
You can use the pivot/unpivot feature in the query editor. Check this out:
http://radacad.com/pivot-and-unpivot-with-power-bi
Hi Anonymous ,
you can do that with Pivot Column in the Power Query Editor.
You select the column Status and click on Pivot Column and than you chose the column Date as you can see on the screenshot below. The screenshot shows the result.