Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count by Date Range - Looking for Help

Hi Everyone,    I have encountered yet another problem that I'm looking to solve.    I have a table with employee names that also contain their start-dates and roll-off dates. Example:   Name ...
Need Help
  • AlB's avatar
    AlB
    6 years ago

     

    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  Datanaut

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
AlB
Icon for Community Champion rankCommunity Champion
6 years ago

 

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  Datanaut