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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
im using this cumulative formula ---- Cumulative_orders = calculate(SUM('New folder'[quantity]),FILTER(all('New folder'[orderDate]),'New folder'[orderDate]<=(1+MAX(('New folder'[orderDate]))))) but the cumulative column is returning same values and not sum that 1,2,8, 10 is returning as 1,2,8,10 but not 1,3,11,21
DAX - Cumulative count for only active customer
nope no luck, still the same. Not sure where Im going wrong. I combined and loaded 3 files from a folder BTW and then sorted ACC to date...
Hi @RiddhimaC
You can get your required output in the following way, for example.
An example pbix file is attached below.
Best regards,
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
6 | |
4 | |
3 |