Forum Discussion
JohannesM
Helper I
4 years agoAckumulated sum with a measure
I have seen posts that explain how to do ackumulated sum from a table column but I need to show ackumulated sum in a table but with a measure as base. Is this possible?
I have a measure that results in column B and now I want to create a measure that gives me column C if shown in a table like below.
Any ideas?
Thanks in advance!
Hi JohannesM
Please try
Ackumulated = SUMX ( FILTER ( ALLSELECTED ( 'Date'[Year] ), 'Date'[Year] <= MAX ( 'Date'[Year] ) ), [Measure] )