The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello all,
I am having problem in calculating cumulative backlog. I tried several dax measures but unable to find the right solution. Is there any problem in creating relationship with date table ?.. I have calculated backlog correctly. But unable to calculate cumulative backlog.
Please help
Regards
Mitesh
Hi @MiteshY, I think this post would be a solutions for you: https://community.fabric.microsoft.com/t5/Desktop/Cumulative-backlog-to-date/td-p/35469
Let me know in case you need any other help.
Thanks,
Vishranti
@VishrantiC Thank you for your response. I have tried that dax measure but didnt get the desired result. I am able to calculate backlog ticket correctly, but facing problem calculating cumulative backlogs.
User | Count |
---|---|
6 | |
4 | |
3 | |
3 | |
2 |
User | Count |
---|---|
9 | |
7 | |
6 | |
5 | |
4 |