Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |