how to unpivot table with multiple columns

[amalrio]

Hi Gurus, 

I have a requirement to unpivot a table with multiple columns, not sure how would I go about it and would ended up giving me incorrect results. below is the image of my tabel, any help is highlty appriciated.

[amitchandak]

@amalrio , Not very clear. But at visual level you can have year as group or filter depending on the visusal

[amitchandak · Accepted solution]

@amalrio, you should be able to select every year and unpivot in this case

https://radacad.com/pivot-and-unpivot-with-power-bi
Video : https://www.youtube.com/watch?v=2HjkBtxSM0g

[amalrio]

Hi @amitchandak , 

thanks a lot for the reply, 

I just found out, so say if I want to group by some of the Project stage say I only want to group the totals for year by when it is implementation? and not whne colse out and define, how do I do that

Thanks again mate

[v-rzhou-msft]

Hi @amalrio 

If you want to sum the values by year and project, you could try group by function in power query editor.

My test table:

I unpivot 2020 and 2021 column , then use gourp by function. Result is as below.

If this reply still couldn't help you solve your problem, please provide me with your screenshot of the result you want. This may make it easier for me to understand your requirement.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.