Generate a boolean column ifor the last hour

[quikin5]

Hi, I have this streaming dataset (Assume current time is 10:50:00 AM)

Time	Values	Last hour
09:42:13 AM	1	No
10:24:56 AM	-1	Yes

How can I generate the last column? This dataset is refreshed every 30 minutes, so some values in this column change automatically whenever the data is refreshed.

Thanks!

[v-diye-msft]

Hi @quikin5 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!

[AiolosZhao · Accepted solution]

Hi @quikin5 ,

Please try to use the below-calculated column, and it works on my desktop and you don't need to worry about the midnight issue I think.

Last Hour = IF(HOUR(Your_Time_Column + 1/24) = HOUR(NOW()),"Yes","No") 

Thanks.

Aiolos Zhao 

[az38]

Hi @quikin5 

smth like

Last hour = 
IF(DATEDIFF([Time], TIME(), HOUR) < 2, "Yes", "No")

but it is going to produce issue at midnight level. you should define how it should work at 00:30 without Date column

as you asked for boolean better so

Last hour = 
IF(DATEDIFF([Time], TIME(), HOUR) < 2, TRUE(), FALSE())