Forum Discussion
Gap between two durations
Hi everyone,
I am trying to calculate gap (difference) between two durations:
Duration beween actual working time of the employees and the time they spend/stay in the workplace,
For calculating the effectiveness of the workday.
it's not like calculate difference between date.
Thank you,
It is much easier to deal with durations as decimal numbers, and then display the result in your desired format at the end. Please see this article.
Calculate and Format Durations in DAX – Hoosier BI
Pat
2 Replies
It is much easier to deal with durations as decimal numbers, and then display the result in your desired format at the end. Please see this article.
Calculate and Format Durations in DAX – Hoosier BI
Pat
Hi,
you can use a calculated column
Column = format(VALUE('Table'[Column2])-VALUE('Table'[Column1]),"hh:nn:ss")or a measureColumn = format(VALUE('Table'[Column2])-VALUE('Table'[Column1]),"hh:nn:ss")If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
