You’re offline. This is a read only version of the page.
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
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.
Share
Report
All responses (
Answers (
834
