Power Query - Sum Last N Columns

Описание к видео 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_D...

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

Комментарии

Информация по комментариям в разработке