Forum Discussion
Zdenek_N
3 years agoNew Member
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
- AhmedxSuper User
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_NNew Member
Thanks