Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Countrows - earlier date

Hi,

 

I have column "Test" and column "Completed" and I want to add column "Test left".

 

Forumla for Test left: =COUNTIF($G$4:$G$11;">"&G4).   
 $G$4:$G$11 = Completed Column, G4 = first column under Completed

 

 

 

 

 

 

 

Thanks

 

 

 

1 Reply

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    try this syntax

    Column = 
VAR __CurrentDate = Table1[Completed]
VAR __TableFiltered = FILTER(Table1, Table1[Completed]>__CurrentDate)
RETURN
COUNTROWS(__TableFiltered)

    it returns null instead of 0 so you may want to add +0 at the end if that makes difference for you