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 |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com