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")
                                )

     

MahyarTF's avatar
MahyarTF
Icon for Memorable Member rankMemorable Member
3 years ago

Hi 

did you use the Interval in your dax :

DateDiffInHour = DATEDIFF( values(Sheet244[In Time]), values(Sheet244[Out Time]),HOUR)

Appreciate your Kudos and please mark my response as a solution if it helps you