Forum Discussion
Get Data from a Nested Table
Hello, within my data table I have several nested tables. Using if conditions I want to check for different scenarios. E.g. if [value_column] > [value_nestedtable1] then 1 else 0 I'm accessing...
You could instead use
Table.AggregateTableColumn(table as table, column as text, aggregations as list) as table
and then do your comparison. So
= Table.AggregateTableColumn(TableOrPriorStepName, {{"ColumnInNestedTable", List.Max, "NewColumnName"}})
A lot of these table functions are very well optimized.
--Nate