Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
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
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |