Dynamic Real-Time Simulation X-Axis

Hello,

I have second resolution calculated/simulated data. The data is forecast data covering the the next year. I am trying to build a demo dashboard that would display a current window of 20 + 1 seconds worth of data. I tried calculated columns or measures or calculated tables by filtering according to current time ... i.e.

LiveViewValue = IF(AND(secondresolution[timestamp]>(NOW()-20/(24*60)),secondresolution[timestamp]<NOW()+1/(60*24)),secondresolution[measurement],BLANK())

But I can't make the calculations, measures that refer to NOW() refresh themselves...

I wonder if it is doable.. Any suggestions?