Forum Discussion
AdministratorMatriz Power Query
Hello
My doubt is that I am bringing some data like these:
And in the power query editor I wanted to know if it is possible to transform them like this:
It is very easy to do it in a PivotTable but I need to bring it to the PowerBi tables in this format
Thank you!
Jose
Hi Anonymous ,
You can pivot the column in the Power Query Editor.
Here's the solution.
1.Select the MES column and then click 'Pivot Column'.
2.Set up as follows, then click OK.
3.Here's the results.
Your question was about Power Query and I moved the post to the Power Query forum for you. Next time if you encounter a problem in Power Query, posting in the correct forum can help you solve it faster.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
You can pivot the column in the Power Query Editor.
Here's the solution.
1.Select the MES column and then click 'Pivot Column'.
2.Set up as follows, then click OK.
3.Here's the results.
Your question was about Power Query and I moved the post to the Power Query forum for you. Next time if you encounter a problem in Power Query, posting in the correct forum can help you solve it faster.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
Syndicate_Admin , Looking at what you posted, not able to get logic. I would not advice data to be broken like that.
use Matrix visual
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Or refer this way
Power bi Excel for P&L , add in app
Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZg
