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.