Forum Discussion

NB919's avatar
NB919
Regular Visitor
4 years ago
Solved

Hour function not working with data

Hello, I am having a problem with using the hour function. What I'm trying to do is round down the minutes to the hour. I tried using the hour function and it returns this message. I'm s...
  • v-yalanwu-msft's avatar
    4 years ago

    Hi, NB919 ;

     

    Such as amitchandak said, you could create a column.

     

    Column = HOUR('PhoneQueueCalls'[time start])

     

    Or create a measure.

     

    Measure = HOUR(MAX('PhoneQueueCalls'[time start]))

     

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.