Custom editing in Power Query

[hakanbacak60]

Hello everyone

I have a table like in the picture

I want to make this table as below?

I gave it as an example, but it continues until 2021-2022-2023.

thanks.

[littlemojopuppy · Accepted solution]

Hi @hakanbacak60.  Remove the column attitude.  Then select the Gender column and find Unpivot Other Columns in the ribbon.  That should get you where you want to be.  Hope this helps!

[hakanbacak60]

Thank you @littlemojopuppy 

I did what you said and it worked. And it was really instructive.

[hakanbacak60]

Thank you. So how can I do the operation in the picture by adding a new column.

[littlemojopuppy · Accepted solution]

Hi @hakanbacak60.  I'm reciting this from memory so it might not be perfect, but if you look a little bit, it might get you where you want to go.  Select columns Gender and Year.  Somewhere on the Ribbon is Transform > Group By.  Look for that.  Sum up the % column.  The downside of doing that is that it's going to remove individual percentages and you're stuck with aggregations which might finder further analysis.

I would suggest creating a DAX measure for this.  Could simply be SUM([%]) but hard to tell without knowing how you intend to use it.

[hakanbacak60]

Thank you @littlemojopuppy 

I did what you said and it worked. And it was really instructive.

[littlemojopuppy · Accepted solution]

Hi @hakanbacak60.  Remove the column attitude.  Then select the Gender column and find Unpivot Other Columns in the ribbon.  That should get you where you want to be.  Hope this helps!