Forum Discussion
Showing a graph based on current time plus 15mins
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 ?
- Anonymous8 years ago
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
2 Replies
- AnonymousNot applicable
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- cheskafaustoFrequent Visitor
Yes! Adding this function has worked! Thanks a bunch! :D