Offset 22 hours

[Anonymous]

Hi! How can I use DAX to offset 22 hours from data?

Thanks in advance!

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Falg =
var _22hours=NOW()-22/24
var _maxtime=MAXX(FILTER(ALL('Table'),HOUR([date])=HOUR(_22hours)&&DAY([date])=DAY(_22hours)),[date])
return
IF(MAX('Table'[date])=_maxtime,1,0)

2. Place [Flag] in Filter, set is =1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Hi @amitchandak, thanks for responding.

I have a report that captures the latest record everytime it refreshes. What I need to do is to display the previous shift. It only gets viewed twice a day - once per shift, 5AM/5PM. Say, at 5PM today, I need to display the last record from 7PM the previous day where if it's 5AM, I need to display the last record from 7AM the previous day.

An alternative is to ensure that it's only refreshed with the database twice a day, maybe at 4:30 so that it's ready by 5. But I am wondering if there's a way that I could do it in DAX or Power Query.

Thank you!

[amitchandak]

@Anonymous , Can explain with example ?

If you need add time 

New column = [Datetime] +time(22,0,0)