Forum Discussion
Solved
Count rows with filtered dates
I am trying to create a measure with a count of people with graduation dates within a specific date range (June 2022 - Sep 2022) so they can be recognized at our event. In this table the graduation d...
I solved my own issue like this:
btm_within_90 = CALCULATE(COUNTROWS('pre-event'), filter('pre-event', 'pre-event'[BTM_End_Date] > date(2022,06,01) && 'pre-event'[BTM_End_Date] < date(2022,09,01)))I had to specify my dates as such - date(2022,06,01)
I solved my own issue like this:
btm_within_90 = CALCULATE(COUNTROWS('pre-event'), filter('pre-event', 'pre-event'[BTM_End_Date] > date(2022,06,01) && 'pre-event'[BTM_End_Date] < date(2022,09,01)))
I had to specify my dates as such - date(2022,06,01)