How to filter days in query editor to make N hours before current day

[NoobAnalyst01]

Hello,

I am trying to build a dashboard for our ops team.

I want to filter by Delivery date=Trunc(sysdate-3/24), becasue i want to the dashboard still return previous's data even people refreshh it at 2am in midanight, so I can you achieve this goal in PowerBi Query Editor?

Thanks

Frank

[v-juanli-msft · Accepted solution]

Hi

“How to filter days in query editor to make N hours before current day”

You could use function DateTime.IsInPreviousHour to indicate whether the given datetime value occurs during the previous number of hours, as determined by the current date and time on the system.

For example, the formula below determine if the hour before the current system time is in the previous two hours.

DateTime.IsInPreviousNHours(DateTime.LocalNow() - #duration(0,2,0,0), 2)

“becasue i want to the dashboard still return previous's data even people refreshh it at 2am in midanight”

You want get the previous's data displaying on dashboard after people refresh it, right?

I test but can’t find a feature to get this. You could see history of refresh only.

Best Regards

Maggie