how to get hour in date & time field

[Anonymous]

Hi Team,

i have connected semantic model to power bi Desktop and the now requirement is when the date & time have ,,, i need only hour in that how i can get that.

Date
01-08-2024 10:16
01-08-2024 11:50
01-08-2024 14:43
01-08-2024 17:00
01-08-2024 11:30

I would expect to see 10, 11 for second row, 14 for the thirid  17 for the fourth and 11 for the fifth .

Please check and share any way we can achive on above concern.

Thanks,

[SachinNandanwar · Accepted solution]

HOUR('Table'[Date])

[shafiz_p · Accepted solution]

Hi @Anonymous  As I can understand, that you want only hour in the same date and time column. If this, you just need to change format. See image below (Just type hh in the format section):

Hit enter and you will get your desired format:

If want to create a new column then use Hour function as @SachinNandanwar  mentioned.

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[SachinNandanwar · Accepted solution]

HOUR('Table'[Date])