topic Re: Countrows - earlier date in DAX Commands and Tips

Countrows - earlier date

Anonymous — Mon, 11 Feb 2019 19:07:11 GMT

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

Re: Countrows - earlier date

Stachu — Mon, 18 Feb 2019 09:52:11 GMT

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