Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
108 | |
88 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |