Milliseconds between

[TomVranken]

Hi everybody,

I'm setting up a control dashboard that includes the monitoring of an API connection.

I have a start and end time stamp of the transactional data and I use the datediff() function to monitor performance of the API. On the most detailled level, the Datediff() function gives me the rounded number of seconds between the two time stamps, but i'm looking for Milliseconds.

I've tried converting the datevalues to decimal number and then subtracting  (end time - start time). This gives me an outcome that does not related to the outcome I get when using dateDiff() in seconds.

Do you know 1) what the outcome is when you convert a datetine in PowerBI to decimal? (it is not Unix/epoch time)

2) How I should approach getting the difference in milliseconds between two datetime timestamps. 

Thanks!

[BeemsC]

Hey,

I don't really understand the first question
For the seconds to milliseconds, just create a new measure where you get the output in seconds * 1000

[TomVranken]

The main question is that I need the millisencond level of detail. If I use the DATEDIFF() function the lowest level is seconds. 300 millisenconds will round of the 0 and 900 milliseconds will round to 1, which in my usecase is not detailled enough.

As an alternative to the DATEDIFF() function I tried to do something like EndDate - StartDate, but that gives me strange results.