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...
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