Forum Discussion
Question about Date Difference format.
Hello! This is my first post here. So, I'm working with a support-ticket database, which includes fields such as "ID number", "Client", "Creation Date", "Close Date", "Solving Agent", etc. One of ...
Anonymous , You can create a new column with diff in seconds
creation-solution time = Datediff(DBNAME[Creation_Date],DBNAME[Close_Date], second)
Then you can create a Avg measure
Avg = average(Table[creation-solution time])
You can new measure for display
Quotient([Avg ],3600) &":" & Quotient(mod([Duration],3600),60) &":" & Mod(mod([Duration],3600),60)