DAX

[AtchayaP]

I have 2categories like male and female I have 4columns(date created, date closed, time created, time closed.

 

[tackytechtom · Accepted solution]

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

[PaulOlding · Accepted solution]

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

[tackytechtom · Accepted solution]

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