IF CONCATENATE EQUAL TO THEN

[cristianml]

Hi,

I need a function that the logic is the following:  If concantenate is equal to comlumn1 & column2 then lookupvalue .. how can I build this in Dax ?

Thanks,

[Anonymous · Accepted solution]

Hi @cristianml 

You need something like the following:

Column = IF("VALUE"  = CONCATENATE(Table1[Column1],Table1[Column2]), 
LOOKUPVALUE(Table2[Column3],Table1[Column1],Table2[Column2]),"DEFAULT_VALUE")

Ta!