Get Data from a Nested Table

[Syndicate_Admin]

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 the data within the nested table by using List.Max([nested_table][column_in_nestedtable]).
That works, however, it slows down my report significantly. 
The data within the nested tables are either numbers or dates.
Is there a better way to access the data within a nested table?

Thanks in advance,
Marco

[Anonymous]

Do your nested tables result from a join, group, or something else.  Of course, if it's from grouping, you can add the Max aggregate in your group step.

--Nate

[Syndicate_Admin]

Thank you for the answer.
I think in that way I aggregate the nested table and only retrieve one value.
Actually, I want to keep the whole nested table as I need it for further calculations.
Then I have the same issue that getting data out of the nested tables slows down my report. 

[Anonymous]

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