Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to imitate VLOOKUP with DAX?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Vlookup problem - unable to get the vlookup property | Excel Programming | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
CAN I FORMAT A ROW TO IMITATE A CONDITIONAL CELL? | Excel Worksheet Functions | |||
can a macro imitate autofilter | Excel Programming |