The PowerQuery function Table.ReplaceValue replaces values in one or more table columns. Lambda expressions provide a way for dynamic replacement.

Article 3 of this series covers "List.Generate". "List.Generate" is one of the most important Power Query functions. As in other languages, "List.Generate" encapsulates a loop and is the equivalent of a For-loop. Understanding List.Generate requires knowledge of lambda expressions.

Part 1 of this series shows how lambda expressions work within Power Query iterators. Lambda expressions placed inside an Power Query iterator function will be executed repeatedly. With each call, the iterator passes different data to the lambda expression.

In part 1 of this series i mentioned that the MSDN does not provide information about the concrete (data) traffic between the lambda expression and the iterator that the lambda expression is part of. Part 2 of this series shows three examples of how Power Query iterator and lambda expression interact with each other.