Forum Discussion
DiKi-I
Post Partisan
Post PartisanNeed help with the data and calculation
Hi, I have a ticket table with ticket creation date, resolve date and close date and its history table with history of tickets with different status in the lifecycle of ticket. Sample data attached...
Data-estDog
Resolver II
Resolver IIIn Transformation view, create a new calculated column and use the DateDiff calculation to produce the duration values.
DATEDIFF function (DAX) - DAX | Microsoft Learn
Or, if you source data is in the db, and you have control over views, add the duration values to the views in question. Also using datediff (in SQL Server)