Forum Discussion
NB919
4 years agoRegular Visitor
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...
- 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.
amitchandak
Super User
4 years agoNB919 , Make sure you creating new column, not measure