Forum Discussion
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...
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.
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