Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
82 | |
65 | |
63 | |
56 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |