Forum Discussion

AlexP1981's avatar
AlexP1981
Frequent Visitor
7 years ago
Solved

Table taking a long time for changes to apply

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 ...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

     

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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's avatar
AlexP1981
Frequent Visitor
7 years ago

Works like a charm.

 

Thanks, Daniel