Forum Discussion

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi Sasha,

     

    Power BI although shows a time as duration when you put that into a visual or make averages it's treated like decimal so you will get a decimal value you need to format your measure to a time, but be aware that making this will make your measure as text and you you will not be abble o use it in a chart as an axis, just cards or tables.

     

    Average Time = FORMAT (SUM(Table[Time]) / SUM(Table[Distance]); "hh:mm:ss")

    Regards,

    MFelix