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 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

 

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

     

2 Replies

  • 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