Forum Discussion

edavila's avatar
edavila
Icon for Helper II rankHelper II
7 years ago

Cumulative Total Revenue from a starting point

Hello experts

 

I will like to see if someone can help me to see how can I fix or create a measure of a total cumulative balance from 2019 going forward as the formula that I'm using is bringing everything from inception

 

please below blue us the revenue

 

thanks  

 

Cumulative Revenue =
CALCULATE([Total Revenue],
FILTER(ALLSELECTED(DIM_Date[Date]),
DIM_Date[Date] <= MAX(DIM_Date[Date])))

4 Replies