Forum Discussion

amitchandak's avatar
amitchandak
Super User
6 years ago

HenryJS 

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")
  • HenryJS's avatar
    HenryJS
    Post Prodigy
    6 years ago

    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"
     
     
    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      HenryJS , Can you provide sample data