Forum Discussion

Nitin03's avatar
Nitin03
Frequent Visitor
3 years ago
Solved

How to find difference between two dates in hours.

Hi I am new to Dax. I want find difference between two dates in hours. I tried by using DATEDIFF function but it is excluding minutes I want result like this Is there another way to so...
Need Help
  • MahyarTF's avatar
    MahyarTF
    3 years ago

    Hi,

    You need to calc the Hour and Minutes separately, then add the particular text Hr and Min to the text one. 

    use the below code for your measure :

    DateDiffInHour = CONCATENATE(
                                 CONCATENATE(
                                             DATEDIFF( values(Sheet244[In Time]), values(Sheet244[Out Time]),hour)
                                             , " hr ")
                                 ,
                                 CONCATENATE(  mod( DATEDIFF( values(Sheet244[In Time]), values(Sheet244[Out Time]), minute), 60)," min")
                                )

     

Nitin03's avatar
Nitin03
Frequent Visitor
3 years ago

Hi MahyarTF  I have already tried by using datediff I want ans like this :

MahyarTF's avatar
MahyarTF
Memorable Member
3 years ago

Hi,

You need to calc the Hour and Minutes separately, then add the particular text Hr and Min to the text one. 

use the below code for your measure :

DateDiffInHour = CONCATENATE(
                             CONCATENATE(
                                         DATEDIFF( values(Sheet244[In Time]), values(Sheet244[Out Time]),hour)
                                         , " hr ")
                             ,
                             CONCATENATE(  mod( DATEDIFF( values(Sheet244[In Time]), values(Sheet244[Out Time]), minute), 60)," min")
                            )