Forum Discussion
HenryJS
Post Prodigy
Post ProdigyMeasure: If column has
Hi all, How do I create a column which: If 'Candidate' has 'Candidate Declaration' & 'CIS Verification' THEN Yes
HenryJS , Can you provide sample data
HenryJSPost Prodigy
Post ProdigyHi amitchandak
I tried this
column = if(calculate(distinctcount([document]),filter('query-results', 'query-results'[Candidate Name]= earlier('query-results'[Candidate Name])
&& earlier([document]) in {"Candidate Declaration" , "CIS Verification"}))=2, "Yes","No")
But it didn't work it just gave "No" for everything when there should definitely be "Yes"
amitchandak
Super User
Super UserHenryJS , Can you provide sample data