How to imitate VLOOKUP with DAX?

[Marc]

Hi,

I have a an issue with a PowerPivot model I am building. I have two
tables, A and B.
Table A consists of phone numbers (Col A, unique list) and table B (is
the fact table) with a lot of phone numbers (in col A, with duplicates
and some not existing in table A) with corresponding addresses (may
contain duplicates and variations) in col B.

I want to lookup from table A and find the first matching phone number
in table B and return the corresponding address.
Pretty easy in Excel with VLOOKUP but unfortunately not in
PowerPivot..?


Can anyone please help?

Best regards,

Marc