Count of Rows if The Date is before Today

[Anonymous]

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 current clients), dates in the past (our lost clients).

I need to calculate the number of lost clients.

I understand that I need to do the following steps:

1. Make sure the ClientEndDate is not Blank
2. compare ClientEndDate <= TODAY()
3. Calculate count of rows if the two abovementioned conditions are met.

Please help me to create a formula.

Thanks 

[Ashish_Mathur]

Hi,

Share a sample dataset and show the expected result on that sample

[Greg_Deckler · Accepted solution]

Measure = COUNTROWS(FILTER('Table',NOT(ISBLANK([ClientEndDate]))&&[ClientEndDate]<TODAY()))

[LRB]

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?

[Anonymous]

Greg, thank you so much! It worked perfectly well 🙂