sum of multipl column from multipl table

[ravikr47]

Can anyone help in sum of mutiple column from mutiple table having the common id in power query editor?

[Anonymous · Accepted solution]

Hi @ravikr47 ,

I made a simple sample for your reference.

Append two tables.

Append queries - Power Query | Microsoft Learn

Then you can use group by to sum up.

Expand All Rows to get the original.

Best Regards,

Stephen Tao

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

[freginier]

You need to merge all tables and then sum your multiple columns

______________________________________________________

If you found this post helpful, please give Kudos C