DAX

Hi AtchayaP ,

I would suggest to first calculate the duration for each of your rows in a new calculated column. After you can drag that new column into a visual with the type column or you create a dedicated measure for it.

Hope this helps!

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

Hi AtchayaP 

You could use a measure like this to give you total time spent.

Time Spent = 
SUMX(
    'Table', 
    DATEDIFF(
        'Table'[date created] + 'Table'[time created],
        'Table'[date closed] + 'Table'[time closed], 
        MINUTE
    )
)

Visualised in a pie chart by type, for example, would give you