Forum Discussion
How to create DAX formula using vlookupvalue with custom text for unmatched records
Hi, I'm able to bring corresponding a_name back to table 1 via vlookupvalue but any unmatched values are showing as blank. Is there a way to assign those unmatched values in a_name to 'Outside of Lon...
Since you have two M:1 relationships, you can just use the RELATED function for your new column on Table1.
a_name = var thisAname = RELATED(Table3[a_name])
return IF(ISBLANK(thisAname), "Outside of London", thisAname)Regards,
Pat
amitchandak
Super User
Super UserAnonymous , if you want a column approch it is two step. From Table 3 to table 2, You can use related
New column in table 2
Name = related(Table3[a_name]) // Assumed they are joined
Table 2 to table 1- New column in table 1
New column =
var _1 = Maxx(filter(Table2, Table2[ID] = Table1[ID]),Table2[Name])
return
if(isblank(_1),"Outside of London" ,_1)
refer this video how copy data from one table to another: https://www.youtube.com/watch?v=czNHt7UXIe8