Power Query (Excel) + M Code | Add a SUBTOTAL or TOTAL column DYNAMICALLY and based on CONDITION

This video will show you how to add a subtotal or total column to dynamically add multiple columns based on condition.
Also, I have additionally explained the List.Alternate function.

Topic:
0:14 - Overview
0:40 - Method 1 - Filter by column/field names
1:40 - Method 2 - Without column names
2:45 - List.Alternate

Workbook:
N/A

[mirrrvelll]

Great video!! Can you do some videos with like variables in PQ? Examples where you are referring some steps from your applied steps and so on - I think that is quite important and super interesting =)

[Sumanth]

Excellent content.. you packed so much great info in 4 minutes.. I was able to follow but if you want to reach out to a bigger audience you need to slow it down .. create separate columns for each function to show the output and then combine the functions .. step by step..just a feedback.. I loved it especially the record to list part of it..can think of many useful applications..

[jhaanand]

Hi KT looking forward to your next video.When is it coming?