Forum Discussion
cumulative sum
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.
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,
KellyDid I answer your question? Mark my reply as a solution!
3 Replies
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,
KellyDid I answer your question? Mark my reply as a solution!
Anonymous , In file -> Options and setting -> Option -> data load ->increase data management cache and try
