Power Query (Excel) + M Code | SUMIFS (Simple to Complex FIFO example)

This video will show you how to use Table.SelectRows() combination with other functions (equivalent to SUMIFS in excel). The example used in the video is FIFO inventory calculation, including simple and complex cases. If you are looking for simple SUMIFS, grouped cumulative sum and more. Example 1 and 2 use the same formula, but example 2 is applied in a complex case where additional functions are required. Topic: 0:00 - Intro Example 1: Simple Case 1:45 - Cell Reference Explained 2:16 - Table.SelectRows and use of custom function Explained 3:05 - List.Sum() + Table.SelectRows() 3:55 - List.Min 4:15 - Recursive function @ Example 2: Complex Case (Include cumulative sum) 5:21 - Example 2 explained 8:23 - Table.InsertRange() 9:30 - Table.Max() 12:19 - Wrap up Workbook: