Forum Discussion
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.
Error message and DAX function
Data I am using
I'm stuck, I've looked on these forums too and haven't found anything
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.
2 Replies
NB919 , Make sure you creating new column, not measure
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.
