Forum Discussion
Adding a custom column to all tables in a structured column
I have a structured column of tables and I want to add a custom column to each of the tables in this structured column.
The custom column would be simple if applied to each table (just the max value of another column) due to how I have used Group By to create the structured column, and I can't think how I would do this after expanding the tables... but I may be thinking about this wrong as I am new to thinking in Power Query.
Is adding a custom column to every table in a structured column doable? Is it advisable?
add a new step after your group-by step
NewStep=Table.Combine(Table.TransformColumns(YourGroupByStepName,{"TableColumnName",each Table.AddColumn(_,"MaxValue",(x)=>List.Max([ColumnName]))})[TableColumnName])
2 Replies
- wdx223_Daniel
Community Champion
add a new step after your group-by step
NewStep=Table.Combine(Table.TransformColumns(YourGroupByStepName,{"TableColumnName",each Table.AddColumn(_,"MaxValue",(x)=>List.Max([ColumnName]))})[TableColumnName])
Brilliant, thanks!
