Forum Discussion
Cumulative Open Actions Dax issues
I'm experiencing troubles with the syntax, which is right, but I want to be able to move values month by month, for example.
IF
Jan as 5 values
feb as 0 values
March 2 values
i want to see this result
Jan with 5 values
feb with 5 values
March with 7 values
i want to be able to see this kind of result but what i have with the dax before is different
Jan ..5 values
March 7 values
as you can see it leavng out the feb even thou as no Values i want to see the jan value move to the feb i will greatful if i can find solution to this urgently
Cumulative Open Actions
= VAR CurrentDate = MAX('Action Tracker'[Date of Action])
RETURN
SUMX( FILTER (
ALLSELECTED('Action Tracker'[Date of Action]),
'Action Tracker'[Date of Action] <= CurrentDate
),
CALCULATE(
COUNTROWS(
FILTER( '
Action Tracker',
'Action Tracker'[Current Status] = "Open"
)
),
ALLEXCEPT('Action Tracker', 'Action Tracker'[Date of Action])
)
)
1 Reply
- Dangar332
Resident Rockstar
HI, Keco5050
as i understood you can try below
here is my datahere out put as a measure
logic behind cumilative sum is below
result = CALCULATE(SUM(**bleep**[sales]),**bleep**[date]<=MAX(**bleep**[date]))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. and don't forget to give kudos.
