Type a few sample results and Power Query works out the transformation that produces them, looking at the first 100 rows, then adds it as a new column.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Column from examples in context, with comparison tables and the common traps.
Terms in this definition
- DCR transformation
A KQL statement inside a data collection rule that drops or reshapes incoming records before storage. Selecting which Windows events the agent gathers is done with XPath instead.
- FIRST
A DAX function available only inside visual calculations. It fetches the value at the start of one axis of the visual's matrix, which makes it handy for comparing each point with the first; its opposite is LAST.