Showing results for 
Search instead for 
Did you mean: 
Jgoldfar New Member
New Member

Distinct Count of New Candidates

I am trying to create a formula that shows the number of candidates that are designated as "New", given that they did not work in the prior in the last 12 months. The formula i am currently using is:


=countrows(filter(addcolumns(values(Table1[CandidateID]),"PreviousCandidates",calculate(countrows(table1),filter(all(Dates),Dates[MTD Period]<min(Dates[MTDPeriod])))),[PreviousCandidates]=0))


However, this formula just shows if the candidates has EVER worked. I need it to show for any period between two dates if they have worked.