Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys,
I want to do a cumulative sum for each category (partner_warehouse_id here) :
Here is what i did for the moment :
Solved! Go to Solution.
Hi @Anonymous
Thanks for reaching out to us.
In column dax code, please try
Nombre d'inscriptions cumulé =
CALCULATE (
SUM ( 'Nombre d''inscriptions 2'[Nombre] ),
FILTER (
ALL ( 'Nombre d''inscriptions 2' ),
'Nombre d''inscriptions 2'[partner_warehouse_id]
= EARLIER ( 'Nombre d''inscriptions 2'[partner_warehouse_id] )
&& 'Nombre d''inscriptions 2'[signup_date]
<= EARLIER ( 'Nombre d''inscriptions 2'[signup_date] )
)
)
Usually, max () is used to get the current row in measure dax code.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Thanks for reaching out to us.
In column dax code, please try
Nombre d'inscriptions cumulé =
CALCULATE (
SUM ( 'Nombre d''inscriptions 2'[Nombre] ),
FILTER (
ALL ( 'Nombre d''inscriptions 2' ),
'Nombre d''inscriptions 2'[partner_warehouse_id]
= EARLIER ( 'Nombre d''inscriptions 2'[partner_warehouse_id] )
&& 'Nombre d''inscriptions 2'[signup_date]
<= EARLIER ( 'Nombre d''inscriptions 2'[signup_date] )
)
)
Usually, max () is used to get the current row in measure dax code.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , try with a small change
Nombre d'inscriptions cumulé = CALCULATE(SUM ( 'Nombre d''inscriptions 2'[Nombre] )
,FILTER(ALL('Nombre d''inscriptions 2'),'Nombre d''inscriptions 2'[partner_warehouse_id] = MAX('Nombre d''inscriptions 2'[partner_warehouse_id])
&&'Nombre d''inscriptions 2'[signup_date]<=MAX('Nombre d''inscriptions 2'[signup_date])))
User | Count |
---|---|
71 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |