Hour function not working with data

[NB919]

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.

Error message and DAX function

Data I am using

I'm stuck, I've looked on these forums too and haven't found anything

[v-yalanwu-msft · Accepted solution]

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.

[amitchandak]

@NB919 , Make sure you creating new column, not measure