LookupValue not doing what I expected

[Anonymous]

I have two tables, one containing a list of Accounts and the other containing a list of Transactions.  

Accounts:

AccountID	Name
0014J00000TY6bJQAT	Joes Sub Shop
0014J00000YMuK1QAL	Bill Boots Barn
0014J00000YMuh8QAD	Johns Jumpsuits
0014J00000TYcRxQAL	Sallys Safes
0014J00000TYdxXQAT	Toms Turkeys
0014J00000TYeXWQA1	Larrys Leggings
0014J00000TYep2QAD	Dons Donuts
0014J00000TYfisQAD	Paulas Pencils
0014J00000TYGxPQAX	Ethans Elephants
0014J00000TXwnyQAD	Helens Helmets
0014J00000TXrpVQAT	Walters Wafers

Transactions:

TransID	AccountID	ReferringAccount
100010101	0014J00000TY6bJQAT	0014J00000TYGxPQAX
100010102	0014J00000YMuK1QAL	0014J00000TXwnyQAD
100010103	0014J00000YMuh8QAD	0014J00000TXrpVQAT
100010104	0014J00000TYcRxQAL
100010105	0014J00000TYdxXQAT
100010106	0014J00000TYeXWQA1
100010107	0014J00000TYep2QAD
100010108	0014J00000TYfisQAD

In the data view, I have created a new column in the Transactions table using the following:

ReferringAccountName = LOOKUPVALUE(Accounts[AccountID],Accounts[Name],Transactions[ReferringAccount],"None")

My resulting data looks like this when I display it in a table visualization:

TransID	AccountID	ReferringAccount	ReferringAccountName
100010104	0014J00000TYcRxQAL
100010105	0014J00000TYdxXQAT
100010107	0014J00000TYep2QAD
100010106	0014J00000TYeXWQA1
100010108	0014J00000TYfisQAD
100010103	0014J00000YMuh8QAD	0014J00000TXrpVQAT	None
100010102	0014J00000YMuK1QAL	0014J00000TXwnyQAD	None
100010101	0014J00000TY6bJQAT	0014J00000TYGxPQAX	None

I expected the table visualization to contain

 

TransID	AccountID	ReferringAccount	ReferringAccountName
100010104	0014J00000TYcRxQAL		None
100010105	0014J00000TYdxXQAT		None
100010107	0014J00000TYep2QAD		None
100010106	0014J00000TYeXWQA1		None
100010108	0014J00000TYfisQAD		None
100010103	0014J00000YMuh8QAD	0014J00000TXrpVQAT	Walters Wafers
100010102	0014J00000YMuK1QAL	0014J00000TXwnyQAD	Helens Helmets
100010101	0014J00000TY6bJQAT	0014J00000TYGxPQAX	Ethans Elephants

What am I doing wrong?

Thanks

[amitchandak · Accepted solution]

@Anonymous , I think it should

ReferringAccountName = LOOKUPVALUE(Accounts[Name],Accounts[AccountID],Transactions[ReferringAccount],"None")

or try like

Maxx(filter(Accounts,Accounts[AccountID] = Transactions[ReferringAccount] ), Accounts[Name])

[Anonymous]

Thanks!  The first suggestion worked on the sample I provided (except those that didn't have a match were left blank instead of saying "none").  However, when I applied it to my real world case, it did not work.  Good news though, the second suggestion worked both times.  Thank you for the quick reply and suggestion.