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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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