Transform month(date) columns to rows

[Anonymous]

Hello to you that reads this!

I'm having a hard time with this situation, any suggestion will be very appreciate!

This dataset I'm working on came with the sales values splitted in "month columns", like this:

How is the best way to work with it? I can't filter it by month, I can't work with date intelligence 😢 .

I guess the best way is to transform this columns into rows, kind like this:

Am I right? If so, PowerBI does this? The "Columns to Row" option didn't seems to work like this.

Best regards! Stay safe.

Vinicius.

[Anonymous]

It works ! Thank you @edhans and @amitchandak .

[edhans]

Great @Anonymous - I could tell you knew what to do when you were looking for a columns to rows transformation, but just needed a bit of help on how Power Query does that. The Unpivot is one of the most powerful and most common transformations I use.

[amitchandak]

@Anonymous , You need to unpivot the table in this case.

https://radacad.com/pivot-and-unpivot-with-power-bi

https://youtu.be/2HjkBtxSM0g

https://youtu.be/oKByyI09Bno
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

[edhans · Accepted solution]

1. Go to Transform Data
2. Click on the IDSales and NameProd columns
3. Right-click and select "Unpivot Other Columns"

That will normalize the data for you.