Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Can anyone help in sum of mutiple column from mutiple table having the common id in power query editor?
Solved! Go to 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.
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.
You need to merge all tables and then sum your multiple columns
______________________________________________________
If you found this post helpful, please give Kudos C