Forum Discussion
echow
Helper II
Helper IIHow to write a DAX for cummulative that does not Reset
How do I create a cummulative member column for the set of data below. Meaning what I should be getting is 2019-12 is 315, 2020-1 is 1,116 and then 2020-2 is 1,414 and so forth.
echow
Add a new column as :This is the new Measure:
Modified Measure.Measure = CALCULATE( COUNT('Table'[VALUE]), FILTER(ALL('Table'),'Table'[YEARMON]<=MAX('Table'[YEARMON]) ))________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply š
Fowmy
Super User
Super Userechow
Add a new column as :
This is the new Measure:
Modified Measure.
Measure =
CALCULATE(
COUNT('Table'[VALUE]),
FILTER(ALL('Table'),'Table'[YEARMON]<=MAX('Table'[YEARMON])
))________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply š