Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I like to change the columns to rows
I like to change from left format to right format
either in power query or excel
Solved! Go to Solution.
Hi,
you can do this in power query editor,
open power query editor:
select the date column
select pivot column on the transform ribbon
in the drop down select your value column
Result:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
In Power Query, go to the Transform Tab, select the Date Column, then click on "Pivot Column" button.
For Values column, select "value".
If this works for you, please remember to mark it as a solution so it can be of help to anyone else searching for similar solutions.
go to power Query,
select your table,
select Date Column
go to transform tab,
Click Pivot
select Value
go to power Query,
select your table,
select Date Column
go to transform tab,
Click Pivot
select Value
In Power Query, go to the Transform Tab, select the Date Column, then click on "Pivot Column" button.
For Values column, select "value".
If this works for you, please remember to mark it as a solution so it can be of help to anyone else searching for similar solutions.
Hi,
you can do this in power query editor,
open power query editor:
select the date column
select pivot column on the transform ribbon
in the drop down select your value column
Result:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
82 | |
72 |