Compare 2 columns from 2 tables

[ColinCH]

Hello

I'm looking for a solution in DAX for a calculated column.

My problem is that I need to compare two columns of two tables with each other. Both tables have different inputs and only a few rows match each other.

For example: I have two tables A and B. Both have entries with dates and numbers.

I need to check the entries of both and print an output in the calculated column.

Table A:

Date	Number
12.01.2022	1111
12.01.2022	3333
23.02.2022	3333
23.02.2022	1111

Table B:

Date	Number	Calculated column (Output)
23.02.2022	1111	Found in table A
28.01.2022	1111	Not found in table A
23.02.2022	2222	Not found in table A
12.01.2022	1111	Found in table A

How would I do this?

Thank you! Sincerely

[mangaus1111 · Accepted solution]

Hi @ColinCH ,

you can try this

Column = 
IF(
    ISBLANK(
            LOOKUPVALUE('Table A'[Number],
                        'Table A'[Date],'Table B'[Date],
                        'Table A'[Number],'Table B'[Number]
                       )
           ),
"Not found in table A",
"Found in table A"
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.