Forum Discussion
Fastest time with milliseconds
Hi there, I want to display the fastest duration with milliseconds from a dataset where time is currently stored in seconds (i.e 65.69 seconds) I would like to display the time in mm:ss.00 forma...
HI Anonymous,
AFAIK, power bi time type not existed millisecond and related functions. How did you data stored? If your records store with a common time format, it will remove milliseconds when you getting data and convert them to power bi data model tables.
I'd like to suggest you extract it to a new column with a whole number format then you can use this DAX formula to calculate.
Regards,
Xiaoxin Sheng