Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
)
)
HI, @Keco5050
as i understood you can try below
here is my data
here 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.
User | Count |
---|---|
51 | |
33 | |
19 | |
15 | |
14 |
User | Count |
---|---|
94 | |
80 | |
37 | |
22 | |
18 |