Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Time not shown properly

Hi guys, I  need to display time as a whole number in order to display it in the graph and therefore this is the code I use:(Below). However, somehow, when I take the filter and seperate such time by...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

    I suggest to use measure rather than calculated column to get the result. Since you want to calculate the average delay, get the average delay in seconds first, then change the format. Here is the PBIX file.

    Average Delay = 
VAR averageDelay =
    ROUNDUP ( AVERAGE ( Sheet1[delay] ), 0 )
VAR Hours =
    INT ( averageDelay / 3600 )
VAR Minutes =
    INT ( ( averageDelay - Hours * 3600 ) / 60 )
VAR Seconds = averageDelay - Hours * 3600 - Minutes * 60
RETURN
    Hours * 100 + Minutes

    Kindly let me know if this helps.
    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.