Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 |
---|---|
14 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
29 | |
17 | |
11 | |
7 | |
5 |