Forum Discussion

cammar's avatar
cammar
Frequent Visitor
3 years ago
Solved

VLOOKUP Type DAX?

Hi Folks,   I need (I am assuming this has to be done via DAX) a formula that does the following:   I have two tables that are related through the following ID's Table1-WORKFLOW_ID and Table2- WF...
  • ChiragGarg2512's avatar
    3 years ago

    The expression except can help in this problem.

     

    This expression can help

    ExcludedWorkflowIDs = EXCEPT( Table1, Table2 )

     

    Except will take every record in Table1 EXCEPT  those in Table2.