Forum Discussion
Transform month(date) columns to rows
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.
- Go to Transform Data
- Click on the IDSales and NameProd columns
- Right-click and select "Unpivot Other Columns"
That will normalize the data for you.
4 Replies
- Go to Transform Data
- Click on the IDSales and NameProd columns
- Right-click and select "Unpivot Other Columns"
That will normalize the data for you.
Anonymous , You need to unpivot the table in this case.
https://radacad.com/pivot-and-unpivot-with-power-bi
https://youtu.be/oKByyI09Bno
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/It works ! Thank you edhans and amitchandak .
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.
