Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to 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!
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!