Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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])
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!