Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone
I'm trying to create the backlog column as follows:
Backlog (OpenTicket + pre_week to backlog)- CloseTicket
I know the Backlog 2 per week (24 Feb - 1 Sea )
Date | OpenTicket | CloseTicket | Delay |
02-08 Mar | 5 | 2 | 5 |
09-15 Mar | 4 | 3 | 6 |
16 -22 Mar | 6 | 2 | 10 |
Could someone else give me a solution to this? It would help me a lot.
Thank you in advance,
@Anonymous
Cumm Sales = CALCULATE([OPen]-[Close],filter(date,date[date] <=maxx(date,date[date])))
Cumm Sales = CALCULATE([OPen]-[Close],,filter(date,date[date] <=max(Sales[Sales Date])))
Or use week Rank, if you do not have Dates
Assume Week table is Date
Cumm Sales = CALCULATE([OPen]-[Close],filter(date,date[Week Rank] <=maxx(date,date[Week Rank])))
How to do
Refer, this is on similar topic https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Can you share sample data and sample output.