cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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:

 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

1 ACCEPTED SOLUTION
Solution Sage

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]
)
),
"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.

Solution Sage

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]
)
),
"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.

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.