Forum Discussion
Count where date greater than
Hi,
How do I create a new measure to say the following please?
mort_no_gtr_2017 = Count (mort_no) where year(mort_date) > 2017
hey try this:
dates greater tham year 2021 = CALCULATE(COUNT('calendar'[Date]),YEAR('calendar'[Date])>2021)you adjust the dax to your exact case, this type of cpunt you want its done with calculate, calculate + sum,average,count etc works as sumif, countif, averageif etc
1 Reply
- StefanoGrimaldi
Resident Rockstar
hey try this:
dates greater tham year 2021 = CALCULATE(COUNT('calendar'[Date]),YEAR('calendar'[Date])>2021)you adjust the dax to your exact case, this type of cpunt you want its done with calculate, calculate + sum,average,count etc works as sumif, countif, averageif etc