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.
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 |
---|---|
66 | |
45 | |
20 | |
19 | |
15 |
User | Count |
---|---|
121 | |
41 | |
38 | |
28 | |
23 |