The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
24 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |