Forum Discussion

CA_Rajeev's avatar
CA_Rajeev
Regular Visitor
4 years ago

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

 

C_summary

 

 

Need Help

2 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    4 years ago

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

  • CA_Rajeev's avatar
    CA_Rajeev
    Regular Visitor
    4 years ago

    Thanks for your reply

     

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

     

    List.Sum[OverheadsTable]{Per Hr}