Matriz Power Query

[Syndicate_Admin]

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

[v-stephen-msft · Accepted solution]

Hi @josefmc08 ,

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.

[v-stephen-msft · Accepted solution]

Hi @josefmc08 ,

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.

[josefmc08 · Accepted solution]

Fantastic, it was exactly what I needed. Thank you!

[amitchandak]

@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