Check if columns Exists in other Table

[luizpansarini]

Hi everyone!

I need to create a measure that checks how columns (Process and Problem) of my table1 exist in table 2. If it does, return the field's Deployment date in new column, it is not, return blank in that new column

How can I do?

Table1Table2

[v-chuncz-msft · Accepted solution]

@luizpansarini,

Better to add a calculated column instead.

Deployment Date =
LOOKUPVALUE (
    Table2[Deployment Date],
    Table2[Category], Table1[Category],
    Table2[Product], Table1[Product],
    Table2[Process], Table1[Process],
    Table2[Problem], Table1[Problem]
)

[vanessafvg]

@luizpansarini  do you need both the problem and process to match?

i am not sure if this is the most elegant way but i would probably create a table in the middle

i.e a unique list of all the problems + processes as a key

and then create that key in either table too, and then join them with bi directional relationships

then all you need to do is create a measure a firstdate(date), lastdate(date) sort of thing but i might be oversimplifying this

[luizpansarini]

i need both to match.

can u show me some steps for this?