Forum Discussion
Require Help to Move Column Value to Column header in POWER QUERY
- 5 years ago
Hello PijushRoy
you can apply some Table.Group by grouping by parameter and create a list from the measure column. In the second step a Table.FromColumns is used to us the data from the grouping-step to create your new table
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8knNSy/JUNJRMq4wNlUIDvT1VYrVQRE2NcAqbI5d2BK7IYZG2JUb4jDd0AK7OUYm2NUbG2AXN0EWD0osSU1RcCtKLSxNzUuuBCoA2u5RNeLlwvJzShLTUxXcixJTUoEyZnrGpvqGhiNbLhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Parameter = _t, Measure = _t]), ChangeType = Table.TransformColumnTypes(Source,{{"Parameter", type text}, {"Measure", type text}}), GroupYourData = Table.Group(ChangeType, {"Parameter"}, {{"Measures", each _[Measure], type table [Parameter=text, Measure=text]}}), CreateYourTable= Table.FromColumns ( GroupYourData[Measures], GroupYourData[Parameter] ) in CreateYourTableCopy paste this code to the advanced editor in a new blank query to see how the solution works.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi
It is working find, Thanks a lots.
Please suggest, How you implement this logic, so I can learn.
Hello PijushRoy
then I would ask you to mark it as solution.
The best way to understand M-code to go to the microsoft power query homepage and check out the functions I used, and try to analyse what exactly does.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy