Inquiry about hour calculation

[Anonymous]

Hi,

I try to extract the hour information from a time field, and I find the result is not always the same as the hour showed in the time data. For example, one is "6/22/2022 10:04:41 PM", the hour should be 22, however when I used hour(time) the result is 21. How to correct this problem? Thanks!

[vanessafvg · Accepted solution]

this is what i get so think you need to share exactly what you doing 

[vanessafvg]

can you please share your calculation or demonstrate how you are doing this. 

[Anonymous]

I used this :   Hour( )

[vanessafvg]

in dax? so you have field that has a date and time and it is a date time type? in it and you create a dax measure / column ?   please share a screenshot of the calc with the result.

calcuation = hour(datetimefield)?

[Anonymous]

Yes, I have a column which is date time type. I want to extract the Hour information and I used add a new column, and this new column =Hour(datetime). But the hour is not alway correct 

[vanessafvg]

when you say its not always correct do you have another example or have you fixed it?  Also how are you placing it on your visual, you could be aggregating that column rather than removing the aggregate if you are doing multiple rows?