Forum Discussion

MalOSB's avatar
MalOSB
Frequent Visitor
8 years ago
Solved

Datesbetween not supported in Direct query

 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

Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    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)
    )
)

     

1 Reply

  • Stachu's avatar
    Stachu
    Community Champion
    8 years ago

    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)
    )
)