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/returni...
Greg_Deckler
Community Champion
Community ChampionGenerally, 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