Formula with multiple iferror and lookupvalue functions

[AldoJavier26]

Currently trying to translate the below excel formula to dax. I gave it a shot below, but it doesn't work. The first 2 lines work, but the following 2 iferror functions just aren't looking up/returning any vaule

Excel

=

IF(LEFT(A8,3)="ABC","SO",
IFERROR(VLOOKUP(A8,BP Map!C:D,2,FALSE),
IFERROR(VLOOKUP(B8,BP Map!B:D,3,FALSE),
IFERROR(VLOOKUP(D8,'PO Map'!A:C,3,FALSE),
""))))

PowerBI

=

IF(LEFT('Aggregate'[Client ID],3)="ABC","SO",

IFERROR(LOOKUPVALUE('BP Map'[BP Office],'BP Map'[Code],'Aggregate'[Client ID]),

IFERROR(LOOKUPVALUE('BP Map'[BP Office],'BP Map'[Client Name],'Aggregate'[Client Name]),

IFERROR(LOOKUPVALUE('PO Map'[Branch],'PO Map'[Code],'Aggregate'[PO Code]),

"")))))

[V-pazhen-msft]

@AldoJavier26 
Lookupvalue cannot be used like that with dax, 

For multiple IFs, I would recommend you to use SWITCH(): https://radacad.com/write-conditional-statement-using-switch-in-dax-and-power-bi

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Greg_Deckler]

Generally, when LOOKUPVALUE doesn't return anything, it is because it has found multiple matching rows. You can try MAXX with a FILTER or use CONCATENATEX with a FILTER to troubleshoot.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490