Forum Discussion
Solved
Measure: 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
Hi 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"
HenryJS , Can you provide sample data