Alternative of IFNA excel function in Power BI

Anonymous — Mon, 20 May 2019 07:19:20 GMT

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.

Re: Alternative of IFNA excel function in Power BI

shomnikoff — Thu, 04 Aug 2022 10:53:31 GMT

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"))

topic Alternative of IFNA excel function in Power BI in DAX Commands and Tips

Alternative of IFNA excel function in Power BI

Re: Alternative of IFNA excel function in Power BI