Display at the report the next atualization

[Anonymous]

I built a financial report that shows some important info.

The report data isn't refreshed in real time, so i scheduled it to refresh 8 times per the day (the maximum permitted)

Now I need to display the next refresh on the report. How can i do this?

I've created a table with the scheduled hours, then I need to verify the next one comparing to the time now().

I am struggling with this, because I don't know which time function is required to accomplish it

How can I do this?

[TeigeGao]

Hi @Anonymous ,

Please refer to the following DAX query:

Measure = IF(TIME(HOUR(NOW()),MINUTE(NOW()),00) >= TIME(17,00,00),TIME(8,00,00),CALCULATE(MIN('Time'[Time]),'Time'[Time] >= TIME(HOUR(NOW()),MINUTE(NOW()),00)))

Best Regards,

Teige

[Anonymous]

Thank you @TeigeGao  for your time.

But that didn't work for me. I need to use the time values stablished on the table . (08:00, 09:30, 10:30, etc). And I couldn't use that measure that way.

[TeigeGao]

Do you mean that they are stored as text format?