Forum Discussion
Solved
Error showed not enough memory by using Earlier
Hello all, I encounter the error by showing not enough memory when using earlier funciton. My purpose is to get accumulated qty based on same date and same sku. The example below: Date_Created ...
Hi nbufff
Can try the window function, It may have better performance.
Accumulated_Qty = SUMX( WINDOW(1,ABS,0,REL,ORDERBY('Basic_1'[Index],ASC,'Basic_1'[Quantity]),PARTITIONBY(Basic_1[Date_Created],'Basic_1'[Material])), 'Basic_1'[Quantity] )Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Great solution. Thanks to let me know the Window fuction.