How to Sum columns by criteria on the column header in Power Query | L0024

The request is simple: I want to add a custom column to a table in Power Query that indicates, in each row, the sum of the values in some of the columns in that row. The challenge is that the column headers of the columns I want to sum may differ each time I get new data.
This lesson will explore several methods to solve this request. One solution will involve the tools available in the Power Query editor only and other native Excel tools. Another solution will include a couple of M Language functions.

________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________

Get access to the EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel

Enroll in my Excel Automation Training Program: https://snapreportschamp.com/waitinglist

Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

Boost your Excel skills with the best Excel books - Mr Excel Book store - https://www.e-junkie.com/ecom/gb.php?...

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn:   / celiajordaoalves  
Facebook:   / solveandexcel  
Twitter: @celia_excel
Instagram: @solveandexcel
YouTube: https:www//   / celiaalvessolveexcel  

#excel #msexcel #exceltraining #msexceltraining #powerquery #powerquerytraining #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA