Forum Discussion
AVERAGE measure produce error
Posted this earlier but a moderator thought it was spam... It isn't. I have only just begun using Power BI and I'm following along with some YouTube videos. I thought I had a good grip, so would ...
You can't use the Time datatype. You have to use DURATION.
Is there anything I can do to convert that to 1 day, 5 hours, 41 min and 41 sec, for example?
daXtreme
Solution Sage
Solution SageYou can't use the Time datatype. You have to use DURATION.
Thanks, that worked. It's giving me an average of "0.45" but Excel says it's 10:13:59 so I need to look at what else I've done wrong. I'm enjoying it though... 🙂
- daXtreme
It's no wonder it says .45 (but I won't go deep into that). I believe you can format a duration datatype using the FORMAT function to turn it into the form [HH]:mm:ss.
- daXtreme
You want to take a look at this post: Solved: Purpose of "Duration" datatype in Power Query - Microsoft Power BI Community