Forum Discussion

cheskafausto's avatar
cheskafausto
Frequent Visitor
8 years ago
Solved

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 ?

  • Anonymous's avatar
    Anonymous
    8 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

  • Anonymous's avatar
    Anonymous
    Not 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

    • cheskafausto's avatar
      cheskafausto
      Frequent Visitor

      Yes! Adding this function has worked! Thanks a bunch! :D