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
amitchandak can you help?
Try
column = if(calculate(distinctcount([document]),filter(table, table[candidate]= earlier(Table[table[candidate]])
&& [document] in {"Candidate Declaration" , "CIS Verification"}))=2, "Yes","No")
or
column = if(calculate(distinctcount([document]),filter(table, table[candidate]= earlier(Table[table[candidate]])
&& earlier([document]) in {"Candidate Declaration" , "CIS Verification"}))=2, "Yes","No")