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[OD_SIGNED_IN], "True")

 

 

 This works as intended.

 

What is needed - In the same table I have another row with dates. I want the CONTAINS messure above to only check for the "True" value in the last 10 days instead of the whole table that contains 2 years of logs.

 

I'm not sure how and if it's possible to wrap the CONTAINS function in a FILTER function or if there's a better solution for this. 

Thanks

Z

  •  

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

     

2 Replies

  •  

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