Power Query.
- Power Query
PowerQuery - Dynamic Text Replacement with Table.ReplaceValue
The PowerQuery function Table.ReplaceValue replaces values in one or more table columns. Lambda expressions provide a way for dynamic replacement.
- Power Query
Lambda Expressions in Power Query - Part 1 - Introduction
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.
- Power Query
Lambda Expressions in Power Query - Part 2 - Context Interaction
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.
- Power Query
Lambda Expressions in Power Query - Part 3 - List.Generate
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.