How to calculate the sum in a specific hour span across two days

[Bridge2022]

Hi all, I encounter a question about calculating the sum in a special time span. 

Here is a part of the table.

How to filter the time from yesterday 23:00 to the next day 6:00?

The DATESBETWEEN function returns a table of dates, but not the hours.

[Bridge2022]

Thanks for your help. 😀
I will try it tommorrow.

[Greg_Deckler]

@Bridge2022 Try:

Measure =
  VAR __Today = TODAY()
  VAR __Yesterday = __Today - 1
  VAR __Start = __Yesterday + TIME(23,0,0)
  VAR __End = __Start + 7/24
RETURN
  SUMX(FILTER('Table',[Date]>=__Start && [Date]<=__End),[Sales])

[amitchandak · Accepted solution]

@Bridge2022 , Assume you have selected date of date in context

Measure =

var _sel = maxx(allselected('Date'), Date[Date])

var _min=_sel-1 + time(23,0,0)

var _max_sel  + time(6,0,0)

return 

calculate(sum(Table[Value]), filter(Table, Table[Date] >= _min &&Table[Date]<=_max))

or create a date only column in your table and use that

new column

Date1 = datevalues([Date])

Measure =

var _sel = maxx(allselected('Table'), Table[Date1])

var _min=_sel-1 + time(23,0,0)

var _max_sel  + time(6,0,0)

return 

calculate(sum(Table[Value]), filter(Table, Table[Date] >= _min &&Table[Date]<=_max))