Need help DAX LOOKUP formula which would work like VLOOKUP

spycein

Board Regular
Joined
Mar 8, 2014
Messages
101
Hello Everyone,

I have two tables

Table 1:-

Voucher No.Invoice No.Invoice AmountInvoice DateVendor Name
1ABC-110014/05/2019ABC Company
1ABC-220014/05/2019ABC Company
2EFG-130031/05/2019EFG Company
2EFG-240031/05/2019EFG Company
3XYZ-150030/06/2019XYZ Company
3XYZ-260030/06/2019XYZ Company


Table No.2:-

Invoice No
ABC-1
ABC-2
EFG-1
EFG-2
XYZ-1
XYZ-2


Now i am looking for a DAX formula in table no.2 which would return the details like vendor name, Invoice Date, Voucher No. etc.

I dont want any power query solution because that would increase my memory. I am looking for need DAX measures which would return the results using the relationship between two tables.

I hope i explained my query properly.

Thank you so much advance.

Best Regards,
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,925
Messages
5,508,146
Members
408,667
Latest member
jh89

This Week's Hot Topics

Top