Conditional Cumulative

[crsjunior]

Greetings, 

I need help with a dax cumulative formula that stops acumulating based on a date. 

I have some activities, and need them to cumulate through tha date they been created ti'll the day they where finished. On the current weeknum only be shown the activities that were created or not finished from the past weeks.

This image is some tests I'm working on, but can't figure a way to stop cumulating only the finished activities.

The green bar is the sum of created activies hours, and the blue is the cumulative

[v-kkf-msft]

Hi @crsjunior ,

What do you mean by stopping cumulating only the finished activities? Doesn't the green bar already exclude finished activities?

Best Regards,
Winniz

[amitchandak]

@crsjunior , you can top based on table date

example

Cumm Sales =

var _max = maxx(allselected(Sales), Sales[Date])

return

CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date]) && ,'Date'[date]  <=_max ))