Showing a graph based on current time plus 15mins

[cheskafausto]

Hi everyone, 

In relation to this post below : 

https://community.powerbi.com/t5/Desktop/Showing-graph-based-on-current-time/td-p/316366

I am trying now to create a graph that shows the next 15mins based on the current local time. I tried using this formula:

#"custom step"=Table.SelectRows(#"Name of Previous Step", each ([Datetime]) <=(DateTime.LocalNow()+0.010416))

 but I get an error saying, I can't add that number to a date.time format. 

btw the number is 1/96 to represent 1 15min interval in a day. 

Any thoughts on this ?

[v-yuezhe-msft · Accepted solution]

@cheskafausto,

Please change your code to the following:

#"custom step"=Table.SelectRows(#"Name of Previous Step", each ([Datetime]) <=(DateTime.LocalNow()+#duration(0,0,15,0)))

Regards,
Lydia

[cheskafausto]

Yes! Adding this function has worked! Thanks a bunch! 😄