Table taking a long time for changes to apply

[AlexP1981]

Hello,

I have a CSV file loaded into Desktop (1.5 M rows, 721 MB in size) I have a calculated column;

List.Sum(List.FirstN(#"Added Index"[Spend Fragmentation],[Index]) which I used to calculate the cumulative values of the Spend Fragmentation column, the problem is this column is taking a long time to calculate.

Does anybody have any ideas on how to speed this up? Any and all solutions welcome.

Thanks

[v-danhe-msft · Accepted solution]

Hi @AlexP1981,

Based on my test, I suggest you use a dax formula to calculate the cumulative values.

Column = CALCULATE(SUM(Sheet13[Spend Fragmentation]),FILTER('Sheet13','Sheet13'[Index]<=EARLIER(Sheet13[Index])))

Result:

Hope it could hep you.

Regards,

Daniel He

[AlexP1981]

Works like a charm.

Thanks, Daniel