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.
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,
User | Count |
---|---|
53 | |
35 | |
20 | |
15 | |
14 |
User | Count |
---|---|
94 | |
80 | |
37 | |
22 | |
18 |