Re-arranging & unpivotting columns (simple task, but need help please)

[Anonymous]

hi all,

i have data in the following format, but i need to re-arrange it somehow in order to analyze it. I think it should be done using the unpivot function, but after some tries i still havent figured out how to do it.

The top table shows how data looks now, but to analyze i think i need it the way table 2 is shown.

I have monthly data only, so maybe i need to make a separate calendar table with months or something, im really not sure how to best reformat the top table to make it "analyzable".

This is of course just an example, the real file has a lot more data, but the methodology should be the same.

How can table 2 be achived using Power BI? please specify how i should do it.. would really appreciate help!

also as a bonus i would like to know the difference between editing the tables using "edit queries" vs just editing the tables as they are using "modelling" anyone can explain the difference?

[Ashish_Mathur · Accepted solution]

Hi,

You may download my file from here.

Hope this helps.

[Anonymous]

I tried to replicate your steps, but i cant get the same result. Here is my process:

[Ashish_Mathur]

Hi,

When you split column, select "At the left most occurence"

[Anonymous]

what is your last step with the pivot column? i tried to pivot each of the columns one at a time without the right result.

[Anonymous]

Figured it out.

I hold ctrl and select both attribute and value and click pivot columns then ok and its complete.

[Ashish_Mathur]

Hi,

If my reply helped, please mark it as Answer.

[Anonymous]

yes thank you. it helped a lot but it was not entirely sufficient, but it got my started, so i could figure out the rest. thank you. will mark as answer.

[Ashish_Mathur]

You are welcome.