Hi all, I'm new to Power BI, so I really hope that you can tell me the solution step by step. I have data like below :KeyTypeAmount1Amount21A60101B30202A40202B70503A10090 Acutally I have a lot of "amount", "amount1,2,3,4,...", and in this example, I want to add 2 columns in Power Query Editor, like below:KeyTypeAmount1Amount2New Amount1New Amount21A601090301B302090302A4020110702B7050110703A1009010090 Logic is, sum(amount1) group by key and type I'm not familiar with the M Query, so I don't know how to add these 2 columns, please help! Thanks in advanced. Aiolos Zhao

Hi, I hope this helps you https://www.myonlinetraininghub.com/excel-forum/power-query/power-query-conditional-sum-column

Anonymous

Not applicable

7 years ago

Solved

In Power Query Editor, how to add columns which need sum and group by?

Hi all,

I'm new to Power BI, so I really hope that you can tell me the solution step by step.

I have data like below :

Acutally I have a lot of "amount", "amount1,2,3,4,...", and in this example, I want to add 2 columns in Power Query Editor, like below:

Logic is, sum(amount1) group by key and type

I'm not familiar with the M Query, so I don't know how to add these 2 columns, please help!

Thanks in advanced.

Aiolos Zhao