Forum Discussion
mifrasmm
Helper I
Helper ICalculate Time to Current Time ( DAX )
Hi I need to create DAX measurement to calculate the timing ( Timer) from Issued time to current time.
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)
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHi 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)
mifrasmmHelper I
Helper I- Phil_Seamark