Forum Discussion
Formula with multiple iferror and lookupvalue functions
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
=
2 Replies
- Greg_Deckler
Community Champion
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
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
