Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I use the following measure:
In the next column:
formated time
null
0.00:01:33.000
null
null
0.00:02:23.3128517
null
null
0.00:02:20.0291237
null
0.00:02:34.3919111
null
null
0.00:02:30.6005375
null
null
0.00:02:18.3312345
I get an error for this data (for bigger numbers- it works fine).
I did not find a built-in function that knows how to work with milliseconds.
Would appreciate the help.
Thanks in advance!
Solved! Go to Solution.
I solved the problem.
I replaced the PERCENTILE.EXC function to PERCENTILE.INC and it worked.
Thank you all!
I solved the problem.
I replaced the PERCENTILE.EXC function to PERCENTILE.INC and it worked.
Thank you all!
Hi @HadasSpier ,
Sorry for that the Time Type in power BI isn't existed millisecond and related functions. How did your 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.
Can you share some screenshots around the issue please? This is not helping much.
Best Regards,
Yuna
Hi @HadasSpier
I have not seen any way in the past on how to get the milliseconds to work.
What I would suggest doing is to possibly put the milliseconds into another seperate column, which will allow you to calculate the milliseconds correctly and then you can update it in your existing measure?
A question I would have is are the milliseconds even required?
Hi GilbertQ!
Yes, milliseconds are required. But I can settle for an output of "less than a second", I tried and could not do it.
Thanks for your help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.