Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |