Datesbetween not supported in Direct query

[MalOSB]

 I am trying to set up a filter in Dax for a time period from 8am Yesterday until 8am today, however, I am using a direct query data source and Datesbetween function is not supported in the direct query mode.

Anybody know a workaround?

Many thanks in advance

Malcolm

[Stachu · Accepted solution]

hmm FILTER with AND criteria?

Measure =
CALCULATE (
    [Measure],
    FILTER (
        'Calendar'[DateTime],
        'Calendar'[DateTime] > TODAY()-1+TIME(8,0,0)
            && 'Calendar'[DateTime] <= TODAY()+TIME(8,0,0)
    )
)