I am learning Power Query and the “each” function comes up a lot. Here is an explanation of its function an purpose for those of us who don’t have a background in functional programming.

https://www.excelguru.ca/blog/2018/01/09/each-keyword-power-query/

This explanation of how Power Query uses anonymous functions that return true of false helped me understand the countorcondition parameter of List.FirstN().

Advertisement