Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
hey all,
im trying to calculate ticket resolution time without having to crossjoin the table with a DATE table.
| Date Created | Work Order | Vehicle | Status | Date Completed |
| 1/5/2022 | 341364 | AB230060 | Closed | 1/10/2022 0:00 |
| 1/5/2022 | 341366 | AB260242 | Open | |
| 1/1/2022 | 341367 | AB210071 | Open | |
| 1/5/2022 | 341368 | AB250554 | Open | |
| 1/5/2022 | 341379 | AB230002 | Closed | 1/10/2022 0:00 |
| 1/5/2022 | 341380 | AB280023 | Open | |
| 1/5/2022 | 341394 | AB230002 | Open | |
| 1/5/2022 | 341395 | AB250426 | Open | |
| 1/5/2022 | 341396 | AB250642 | Open | |
| 1/5/2022 | 341398 | AB240121 | Open | |
| 1/5/2022 | 341399 | AB230071 | Open | |
| 1/5/2022 | 341404 | AB250692 | Open | |
| 1/2/2022 | 341472 | AB250691 | Open | |
| 1/2/2022 | 341479 | AB250570 | Open | |
| 1/2/2022 | 341481 | AB250311 | Open | |
| 1/2/2022 | 341486 | AB250309 | Open | |
| 1/2/2022 | 341488 | AB250683 | Open | |
| 1/1/2022 | 341490 | AB250460 | Closed | 1/5/2022 0:00 |
| 1/5/2022 | 341491 | AB250638 | Open | |
| 1/1/2022 | 341492 | AB290059 | Open | |
| 1/1/2022 | 341496 | AB250464 | Closed | 1/5/2022 0:00 |
| 1/2/2022 | 341497 | AB250645 | Open | |
| 1/2/2022 | 341686 | AB230137 | Open | |
| 1/2/2022 | 341688 | AB240112 | Open | |
| 1/2/2022 | 341693 | AB260054 | Open | |
| 1/5/2022 | 341779 | AB230009 | Closed | 1/10/2022 0:00 |
| 1/5/2022 | 341803 | AB250088 | Closed | 1/10/2022 0:00 |
| 1/1/2022 | 341811 | AB260116 | Open | |
| 1/1/2022 | 341844 | AB230307 | Open | |
| 1/5/2022 | 341867 | AB250450 | Open |
I'm hoping to end up with a Year/Month/Day table and see the trend of Mean Time To Resolution as a KPI
Hi @Alasharim ,
Is it convenient to share the results you are expecting regarding this data as a display? Not quite sure exactly what you are looking for.
Best Regards
Lucien
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |