Forum Discussion
Count by Date Range - Looking for Help
Measure = VAR CutOffDate_ = MAX ( CalendarTable[Date] ) RETURN COUNTROWS ( FILTER ( Table1, Table1[Roll-Off Date] > CutOffDate_ || ISBLANK( Table1[Roll-Off Date] ) ) )Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Community ChampionHi Anonymous
1. Create a standard calendar table (no relationships to the table you show). Place month and year in a slicer.
2. Place this measure in a card visual (assumes only one row per employee in the table you show (Table1))
Measure =
VAR CutOffDate_ =
MAX ( CalendarTable[Date] )
RETURN
COUNTROWS ( FILTER ( Table1, Table1[Roll-Off Date] > CutOffDate_ ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi AlB ,
Thanks for the Suggestion.
I already had a rolling-calendar created, There is no relationship between the Employe Table and calendar.
What if the Roll-off date contains a lot of "Null" values as the people who are not yet rolled-off will not have the date in there.
is it possible to amend the formula so that it also counts the null values too please?
BR,
Kris
- AlB
Measure = VAR CutOffDate_ = MAX ( CalendarTable[Date] ) RETURN COUNTROWS ( FILTER ( Table1, Table1[Roll-Off Date] > CutOffDate_ || ISBLANK( Table1[Roll-Off Date] ) ) )Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers