Need help DAX LOOKUP formula which would work like VLOOKUP

[spycein]

Hello Everyone,

I have two tables

Table 1:-

Voucher No.	Invoice No.	Invoice Amount	Invoice Date	Vendor Name
1	ABC-1	100	14/05/2019	ABC Company
1	ABC-2	200	14/05/2019	ABC Company
2	EFG-1	300	31/05/2019	EFG Company
2	EFG-2	400	31/05/2019	EFG Company
3	XYZ-1	500	30/06/2019	XYZ Company
3	XYZ-2	600	30/06/2019	XYZ 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,

 

[sandy666]

I dont want any power query solution because that would increase my memory

wrong, rather DAX increase memory and file size not Power Query
but this is your choice
good luck ?