Forum Discussion

sshriner's avatar
sshriner
Advocate I
9 years ago

Time Duration including milliseconds

Hoping someone can help.  I have a table with transaction start times that have minutes, seconds and milliseconds.  i have not been able to find a way to calculate or display a duration that includes...
sshriner's avatar
sshriner
Advocate I
9 years ago

I've seen that post, thank you.

 

When I import the data into Power BI it comes over as a data/time data type, but the milliseconds are dropped from the display.  i can calculate duration, but the milliseconds are either dropped or rounded, so my durations are not accurate when compared to my original data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi sshriner,

     

    Based on my test, Power BI desktop cannot properly handle the milliseconds. As a workaround to your scenario, you can split the Time part from your column in your data source, convert the time to number of milliseconds in new columns, then import new columns into Power BI Desktop which should be defined as numeric data type, then calculate duration.


    Thanks,
    Lydia Zhang