Calculate Time to Current Time ( DAX )

[mifrasmm]

Hi 

I need to create DAX measurement to calculate the timing ( Timer)  from Issued time to current time.

[tringuyenminh92]

Hi @mifrasmm,

You could try with DATEDIFF method with interval is second. after that convert to format you want: hh:mm:ss by topic

Create calculated column:

Duration in second = DATEDIFF(Sheet1[ISSUED_DATE],NOW(),SECOND)

Format your timing:

Timer = RIGHT ( "0" & INT (Sheet1[Duration in second] / 3600 ), 2 )
    & ":"
    & RIGHT (
        "0"
            & INT ( (Sheet1[Duration in second] - INT (Sheet1[Duration in second]/ 3600 ) * 3600 ) / 60 ),
        2
    )
    & ":"
    & RIGHT ( "0" & MOD (Sheet1[Duration in second], 3600 ), 2 )

[Phil_Seamark · Accepted solution]

Hi @mifrasmm

The DATEDIFF function will return a number based on the difference between two times in your interval of choice.  In the below example it returns the number of Seconds, but you can chose MINUTES, HOURS, DAYS etc.

NOW() returns the current time to the second.

Seconds = DATEDIFF([Column1],NOW(),SECOND)

[mifrasmm]

@Phil_Seamark

Got it , its working is there any way i can make H:mm

[mifrasmm]

@Phil_Seamark thanks for replying 

I thing sometinng worng , i tried as measure and new column 

[Phil_Seamark]

Hi @mifrasmm

Is Issued_date a column or a measure?