Forum Discussion

JoshB_'s avatar
JoshB_
Regular Visitor
4 years ago
Solved

Merge Tables based on first non-blank condition

Hi there, I have two tables, each table contains employees and contains an ID, a personal Email, and a work email   Unfortunately, they don't match very well, and there will be no way of cleaning ...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    JoshB_ 

    I did it in a different way, please check:

    Col A = 
VAR _ID = [ID]
VAR _PMAIL = [Personal Email]
VAR _WMAIL = [Work Email]
RETURN
MAXX(
    FILTER(
        'Table-1',
        'Table-1'[ID] = _ID || 'Table-1'[Personal Email] = _PMAIL || 'Table-1'[Work Email] = _WMAIL
    ),
    'Table-1'[Col A]
)

     



Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

JoshB_ 

I did it in a different way, please check:

Col A = 
VAR _ID = [ID]
VAR _PMAIL = [Personal Email]
VAR _WMAIL = [Work Email]
RETURN
MAXX(
    FILTER(
        'Table-1',
        'Table-1'[ID] = _ID || 'Table-1'[Personal Email] = _PMAIL || 'Table-1'[Work Email] = _WMAIL
    ),
    'Table-1'[Col A]
)

 



JoshB_'s avatar
JoshB_
Regular Visitor
4 years ago

Perfect, thank you.