Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Check object in many table whether it is in masterdata table

Hi All,   I have a transaction table called "Activities" and a Master data table called "projects".   Sometimes new projects are added in the activities table and I need to know so I can update t...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    You can add the following column in 'Find new addition' table. 

    Column 2 = IF('Find new addition'[ProjectName] IN VALUES(ProjectList[ProjectName]),TRUE(),FALSE())

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I added a new column in the project table. 

    The formula gave an error. The last expression of countX is not recognized.

    here is the Link to the file