Get Data from a Nested Table

(0) Share

Report

Posted on by Community Power Pla...

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

nested_table_exam...

All responses (1)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Get Data from a Nested Table

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.