Forum Discussion

phial-2's avatar
phial-2
Frequent Visitor
2 years ago
Solved

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 va...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    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])

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
2 years ago

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])

  • phial-2's avatar
    phial-2
    Frequent Visitor
    2 years ago

    Brilliant, thanks!