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...
Hi sshriner,
Could you please share sample data of your table and post expected result here? Based on my test, Power BI Desktop doesn’t display milliseconds in its original format, it displays time column containing milliseconds to the following format.
You can directly substract time values of two columns. Assume that you have two DateTime columns, you can split Date and Time part and calculate them seperately. There is an example for your reference, for more details about what functions are used to calculate duration, please review the example in the attached PBIX file.
Thanks,
Lydia Zhang