topic Time value for an Average Column in DAX Commands and Tips

Time value for an Average Column

ranis1227 — Tue, 08 Nov 2022 20:03:43 GMT

Hello,

I created a summarized table and am trying to convert an average time value (Average Hour Time in this case) to a time format (HH:MM:SS). See Screenshot:

So 12.11 for Medicine Emory A should convert to roughly 12:07.

Any help will be greatly appreciated.

Re: Time value for an Average Column

VahidDM — Tue, 08 Nov 2022 22:00:40 GMT

Hi ranis1227

Check out the below links and you will find how to convert your number to time:
https://community.powerbi.com/t5/Desktop/Convert-Decimal-Duration-in-HH-MM-SS-format/m-p/959061
https://community.powerbi.com/t5/Power-Query/How-to-convert-decimal-time-to-hh-mm-and-summarize-that-column/td-p/2487381

https://www.myonlinetraininghub.com/converting-decimal-time-to-days-hours-minutes-in-power-bi

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

LinkedIn | Twitter | Blog | YouTube

Re: Time value for an Average Column

v-yinliw-msft — Wed, 09 Nov 2022 05:20:55 GMT

Hi ranis1227 ,

You can try this method:

New a measure:

Average_Time = var _hours = ROUNDDOWN(SUM('Table'[Average Hour Time]), 0) var _minutes = (SUM('Table'[Average Hour Time]) - _hours) * 60 var _seconds = (_minutes - ROUNDDOWN(_minutes, 0)) * 60 return TIME(_hours, _minutes, _seconds)

Need to change the type here:

The result is:

Hope this helps you. Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Time value for an Average Column

ranis1227 — Wed, 09 Nov 2022 13:16:17 GMT

Thank you v-yinliw-msft . This is exactly what I needed.