Can PowerQuery append rows based on columns?

Question

Hello StackOverflow Community,

I have a Dataset where the monthly volume's values per Model is shown in multiple columns instead of one. I.E:

Model Jan Feb Mar Apr May

 A        5     12     26      56     23

Is it possible through PowerBI's PowerQuery to create one "Month" column where its values are being appended? Example:

Model Month Volume

 A         Jan        5

 A         Feb       12

 A         Mar       26

 A         Apr        56

 A         May       23

Thanks in advance.

Right click first column header and choose Unpivot other columns. — horseyride
– horseyride, Commented Jul 23, 2020 at 20:20

Jon · Accepted Answer · 2020-07-23 20:30:22Z

1

You need to use 'Unpivot columns', in the transform options of the query editor

Select the columns you want, then Unpivot. You should give you this:

It will name the new columns Attribute and Value, you can then rename them to what you want. FYI when the next month (Jun) is added to the source it should unpivot that column automatically.

answered Jul 23, 2020 at 20:30

Jon

4,9953 gold badges16 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ruben Dario Colmenares Over a year ago

Thanks, this is was I needed.

Collectives™ on Stack Overflow

Can PowerQuery append rows based on columns?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related