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.
Hello all!
I need your help to find a solution for this matter. The idea is to calculate the average age of the tickets from my backlog per day. The average age must be in days (not in minutes or hours). Let me give you an example.
TICKET NUMBER | CREATION DATE | END DATE |
40500 | 01/03/2019 8:45 | 04/03/2019 10:00 |
40501 | 02/03/2019 10:30 | 05/03/2019 11:00 |
40502 | 03/03/2019 12:05 | 06/03/2019 17:00 |
40503 | 04/03/2019 16:57 | 06/03/2019 16:00 |
This an example of a ticket table. I need to calculate de age of each tickets taking a date as a reference (DATE column).
TICKET Age per day | |||||
DATE | AVERAGE BACKLOG AGE | 40500 | 40501 | 40502 | 40503 |
02/03/2019 0:00 | 0,635416667 | 0,6354 | |||
03/03/2019 0:00 | 1,098958333 | 1,6354 | 0,5625 | ||
04/03/2019 0:00 | 1,029513889 | 1,5625 | 0,4965 | ||
05/03/2019 0:00 | 1,450925926 | 2,5625 | 1,4965 | 0,2937 |
I need to obtain a formula to do the same calculus as I have in AVERAGE BACKLOG AGE column.
Maybe a temporal table would be the solution (I have one for the calculus of the number of tickets of backlog per day), but in this case I need to calculate the average age of the tickets from the backlog per day.
Any ideas? Thanks for your help as always 🙂
Hi @Anonymous ,
How did you get the TICKET Age here? Is that the data from fact table or not?
Regards,
Frank
The calculus on that table is built in Excel, not in Power BI. That's an example of what I need to calculate in PBI.
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |