Forum Discussion

Epinephrin's avatar
Epinephrin
Regular Visitor
6 years ago
Solved

How can I count the values without VLOOKUP?

Hello everyone,   I would like to check if a value in column A already has any value in column B (no matter which one). Normally I would solve the problem with VLOOKUP:   =IF(VLOOKUP(A1;$A$1:$B$...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Epinephrin ,

     

    Something like below?

    Column = IF('Table'[Column1] in VALUES('Table'[Column2]),"YES","NO")

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Epinephrin ,

Try new column like

Count = countx(filter(Table,table[colA] =earlier(Table[ColB])),Table[ColB])

or

Flag = if(isblank(countx(filter(Table,table[colA] =earlier(Table[ColB])),Table[ColB])) ="No","Yes")

  • Epinephrin's avatar
    Epinephrin
    Regular Visitor
    6 years ago

    Hey,

     

    thank you. But the results from your first formular are empty and the second doesn't work because: 

    DAX comparisons do not support comparisons between True/False and Text type(?).

    • DebbieE's avatar
      DebbieE
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hi @Epinephrin

       

      Have you got a few rows of example data to go with this?