Return NOW if it's the current hour

[Anonymous]

Hello,

I am trying to create a column with empty values if it's not the current hour, else return NOW.

I tried this:

CurrentHour = IF(Datatime_long[Date] = YEAR(TODAY()) && Datatime_long[Time] = HOUR(NOW()), "NOW","")

Could somebody spot the mistake or is there another way to tackle this ?

Thanks in advance

[camargos88]

@Anonymous ,

Try this one:

CurrentHour = IF(YEAR(Datatime_long[Date]) = YEAR(TODAY()) && Datatime_long[Time] = HOUR(NOW()), "NOW","")

OR

CurrentHour = IF(
DATE(YEAR(Datatime_long[Date]), MONTH(Datatime_long[Date]), DAY(Datatime_long[Date])
 = TODAY() && Datatime_long[Time] = HOUR(NOW()), "NOW","")

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format?

[Anonymous]

@amitchandak 

The data looks like this but all i get is empty values under the currentHour