Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Count of Rows if The Date is before Today

Hi,   Most probably, it is super easy, but I don't know how to do this in one formula. Please help.   I have a column 'ClientEndDate' with empty values (not a client), dates in the future (our cu...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago
    Measure = COUNTROWS(FILTER('Table',NOT(ISBLANK([ClientEndDate]))&&[ClientEndDate]<TODAY()))
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago
Measure = COUNTROWS(FILTER('Table',NOT(ISBLANK([ClientEndDate]))&&[ClientEndDate]<TODAY()))
LRB's avatar
LRB
New Member
3 years ago

For some reason the formula you provided is counting more than the dates prior to today. I have a  column ("(*) BL Project Finish") in a table ("TASK") that has dates and I want to count the dates in that column that are before today. I tweeked your formulate to fit my data but it is counting more than the dates that are not blank and prior to TODAY. Here is the formula I am using:

BL Project Finish To Date = COUNTROWS(FILTER('TASK',NOT(ISBLANK([(*)BL Project Finish]))&&[(*)BL1 Finish]<TODAY()))
 
Am I missing something?