cumulative sum

[Anonymous]

I want to have a cumulative value for each row that you may see in the "TARGET" column.

But I have more than 1 Million rows so I keep getting the same error as "not enough memory error" while I applied codes like below:

--------------------------------------------------------------------------------

---Running Total COLUMN =

CALCULATE (

    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),

    ALL ( 'All Web Site Data (2)' ),

    'All Web Site Data (2)'[Date] <= EARLIER ( 'All Web Site Data (2)'[Date] )

)---

or

Running Total MEASURE = 

CALCULATE (

    SUM ( 'All Web Site Data (2)'[UniquePageviews] ),

    FILTER (

        ALL ( 'All Web Site Data (2)' ),

        'All Web Site Data (2)'[Date] <= MAX ( 'All Web Site Data (2)'[Date] )

    )

)

---------------------------------------------------------------------------

I would be glad if you have an effective solution and suggestions to get a quick result without straining the system memory.

Thanks for all.

 

[v-kelly-msft · Accepted solution]

Hi  @Anonymous,

Your dax expression has no problem,try increasing the Maximum allowed to 16000 under File / Options and Settings / Options / Global / Data Load.  Data Cache Management Options.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[amitchandak]

@Anonymous , In file -> Options and setting -> Option -> data load ->increase data management cache and try

[Anonymous]

Hi, @amitchandak 

thanks for your answer. I tried this before but it didn't work.