Forum Discussion
(Yet another) time query
I think I've solved it myself!
I was asking for daily data, and Power BI was trying to average, but by removing day from my query, it is retuening the expected results.
Thanks for your help!
Anonymous
Hi,
If the column is loading as duration and you need to convert it as total seconds then use following:
Transform or Add Column > Duration (Under Date & Time segment) > Total Seconds
It will convert the existing duration column in seconds.
I am not sure about your second requirement because as per my experience, average calculation in Power BI gives accurate results. I would recommend you to calcualte average after performing the steps above.
Rgds,
Vivek
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi vivran
As the screenshot will show, I have explored the Time functions under transforming columns, and I cannot see find a seconds option:
What I did find though was the 'Duration' button lit, and that gives an option to split out seconds from the duration, and, although it doesn't deal with milliseconds, this may move me further forward.
Thanks for taking the time to reply
Daniel