IF, VLOOKUP, ISNA -> DAX

[haassiej]

Hello all,

I have a question about translating an Excel function to Power BI. I've already searched around and came across different DAX solutions, I only get this not working.

I would like to apply the Excel formula below to Power BI.

= IF ($ N2 = "NO XX"; M2; IF (VLOOKUP ($ Z2; TABLE2! AB: AE; 4; FALSE)); "No Match with XX"; VLOOKUP ($ Z2; TABLE2! AB: AE; 4; FALSE)))

The values N2 and M2 are in TABLE1 and if they are not "NO XX" then he will look in TABLE2.

Can someone help me on my way?

Thanks in advance

[v-yuezhe-msft · Accepted solution]

@haassiej,

Create a column using DAX below.

Column = IF(Table1[N]="No XX",Table1[M],IF(ISBLANK(LOOKUPVALUE(Table2[Column4],Table2[Column1],Table1[Z])),"No match with XX",LOOKUPVALUE(Table2[Column4],Table2[Column1],Table1[Z])))



Regards,
Lydia

[haassiej]

@v-yuezhe-msft

Thanks for your reply!

Have your columns a join/relationship with each other? My tables in Power BI doesn't have an relationship.

[v-yuezhe-msft]

@haassiej,

There is no relationship between the tables in my scenario.

Regards,