Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Please could someone help me to elaborate the table to calculate the accumulated, I have no idea how I could do it or how to approach it
My Data
I want to make this table or graph
Month | Count Ticket SLA breached | I do not need this column, I am putting it so that you can understand the calculation |
Ene-21 | 0 | Id01 was created in January but breached SLA from February to July (expected resolution date to resolved date) |
Feb-21 | 1 | Because id01 breached sla until resolved date (25/07), id02 was created but it just broke in March |
Mar-21 | 2 | Because id01 breached sla until resolved date ( 25/07 ) and id02 breached sla until resolved date (20/05) |
Abr-21 | 2 | Because id01 breached sla until resolved date ( 25/07 ) and id02 breached sla until resolved date (20/05) |
May-21 | 2 | Because id01 breached sla until resolved date ( 25/07 ) and id02 breached sla until resolved date (20/05) |
Jun-21 | 1 | Because id01 breached sla until resolved date ( 25/07 ) |
Jul-21 | 1 | Because id01 breached sla until resolved date ( 25/07 ) |
Ago-21 | 0 |
Solved! Go to Solution.
Count Tickets SLA Breached = CALCULATE(COUNTROWS('Table'),'Table'[Resolved Date]>Min(Dates[Date]),'Table'[Created Date]<Max(Dates[Date])-25)
See attached. This also works on day level granularity.
Excellent solution, another question how can i show the ID for each month?
Slicer Month: Selected Mar-21
Result Table:
Id | Created |
id01 | 10/01/21 |
id02 | 11/02/21 |
Those data points do not depend on the slicer. Create a separate table visual that has only Id and Created columns.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |