if error vllokup formual in BI

[123rickfear]

Hi all,

new to BI to apologies if my wording is incorrect.

I am converting a report I have into BI, but can't work out how to translate the formula from one to the other.

In excel I have:

=IFERROR(VLOOKUP(G3|'FUNCTION NEW'!A:C|3|0)|IFERROR(VLOOKUP(LEFT(G3|4)|'FUNCTION NEW'!A:C|3|0)|VLOOKUP(LEFT(G3|2)|'FUNCTION NEW'!A:C|3|0))|"")

I have the first part working with Column = related('Org Functions'[Org Function])

but now I need to add on the iferror use first 4 figures, if error use first 2 part.

any help would be greatly appreciated.

Thanks

Rick

 

[123rickfear]

no longer needed.

thanks