Forum Discussion
cristianml
Post Prodigy
Post ProdigyIF CONCATENATE EQUAL TO THEN
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,
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!
1 Reply
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!