Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
CA_Rajeev
Regular Visitor

How to add a sum of column from another table using custom column option in Power Query ?

 

Please help me in this case

 

I need to add the sum of Per Hour Columm which is 658 from overheads Table to another  query ( C_summary)  using custom column option

 

Please Help

 

Overheads Table

CA_Rajeev_0-1655804697387.png

 

C_summary

CA_Rajeev_1-1655805011854.png

 

 

2 REPLIES 2
CA_Rajeev
Regular Visitor

Thanks for your reply

 

But i am new to power Query can you confirm is this the way

 

List.Sum[OverheadsTable]{Per Hr}

HotChilli
Super User
Super User

You do this with List.Sum passing the table and column name

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors