Forum Discussion

ColinCH's avatar
ColinCH
Regular Visitor
3 years ago
Solved

Compare 2 columns from 2 tables

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:

 

DateNumber
12.01.20221111
12.01.20223333
23.02.20223333
23.02.20221111

 

Table B:

DateNumberCalculated column (Output)
23.02.20221111Found in table A
28.01.20221111Not found in table A
23.02.20222222

Not found in table A

12.01.20221111

Found in table A

 

 

How would I do this?

 

Thank you! Sincerely

Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    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.

     

1 Reply

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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.