creating new table with new column

[OSS]

Dear members 

Below you can find the sample of my data. I think explanation of my problem with the sample tables would be easier. 

Blue table shows share for each product group. Orange table shows total expense amount.

I have created measures by multiplying total expense amount from orange table with related column from blue table.

BUT, my task is to add new column and show product groups in order to make another relationships with product group table.

Green tables are my expected results. I have tried number of ways and get huge mess.

Could you please help me with the the most effective and easy way to my goal?

[v-chuncz-msft · Accepted solution]

@OSS,

You may select Unpivot Columns in Query Editor first.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415

[OSS]

Thank you very much. It is definitely what I was looking for. You save me 🙂