Power Query - Sum Last N Columns

Learn how to dynamically discover and aggregate (ex., SUM) the last N columns of a table regardless of column name. Also, see how to filter and assign data types by column position rather than column name. Many cool tricks are involved in the solution. File Download Link: https://www.bcti.com//wp-content/YT_Downloads/BCTI_PQ_LastNCols.zip 01:21 Solving the Problems Statically 02:05 Understanding the Limits of a Static Solution 03:32 Removing Premature Steps 03:44 Removing Unwanted Columns 06:23 Testing for Dynamic Column Selection 06:49 Summing the Last 3 Columns 07:06 Setting Data Types by Position 10:01 Summing the Last 3 Columns 13:09 Testing the Fully Dynamic Solution 13:33 Overview of the M Code 14:21 Be Mindful When Working With Excel Tables