Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!