Alternative of IFNA excel function in Power BI

[Anonymous]

Hi there!

I have an excel report which I want to build in Power BI. In excel, I have applied this formula 

=IF(A2="C","Client",IFNA(VLOOKUP(B2,$E$3:$F$15,2,0),"Internal"))

in one column. I want to replicate same in Power BI in new calculated column, but since IFNA function is not available in Power BI got no success.

Here is the snipnet of excel table

Thank you in advance.

[shomnikoff]

Hey there,

Alternative for the IFNA function is IFERROR(). 

So the formula would look like this I assume =IF('Table1'[JOBIND]="C","Client",IFERROR(LOOKUPVALUE('Table2'[F],'Table2'[E],'Table1'[Personal]),"Internal"))