Forum Discussion

Zdenek_N's avatar
Zdenek_N
New Member
3 years ago
Solved

DAX date filter with CONTAINS function

Hi all,   I have a below measure that checks if a OD_SIGNED_IN row in WINOS_ONEDRIVE_MONITOR table contains a "True" value.     Measure = CONTAINS(WINOS_ONEDRIVE_MONITOR,WINOS_ONEDRIVE_MONITOR[...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

     

    Measure =
VAR _toDay = tODAY()
VAR _Last10 dayes = _toDay-10
RETURN
CALCULATE (
Measure = CONTAINS(WINOS_ONEDRIVE_MONITOR,WINOS_ONEDRIVE_MONITOR[OD_SIGNED_IN], "True"), 'CALANDAR'[Date]>=_Last10 dayes&&'CALANDAR'[Date]<= _toDay

----
Measure =
CALCULATE (
Measure = CONTAINS(WINOS_ONEDRIVE_MONITOR,WINOS_ONEDRIVE_MONITOR[OD_SIGNED_IN], "True"), DATESINPERIOD('CALANDAR'[Date],LASTDATE('CALANDAR'[Date]),-10,DAY))

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

 

Measure =
VAR _toDay = tODAY()
VAR _Last10 dayes = _toDay-10
RETURN
CALCULATE (
Measure = CONTAINS(WINOS_ONEDRIVE_MONITOR,WINOS_ONEDRIVE_MONITOR[OD_SIGNED_IN], "True"), 'CALANDAR'[Date]>=_Last10 dayes&&'CALANDAR'[Date]<= _toDay

----
Measure =
CALCULATE (
Measure = CONTAINS(WINOS_ONEDRIVE_MONITOR,WINOS_ONEDRIVE_MONITOR[OD_SIGNED_IN], "True"), DATESINPERIOD('CALANDAR'[Date],LASTDATE('CALANDAR'[Date]),-10,DAY))

 

  • Zdenek_N's avatar
    Zdenek_N
    New Member
    3 years ago

    Thanks