Forum Discussion
DAX command
Hi,
How can I create the following excel formual in new column (W/Wo_QC) between 2 columns (Opp_ID) & (LOA_ID) in different tables using DAX in Power Bi
=IF(ISNA(VLOOKUP(L2,QC!AV:AV,1,FALSE)),"Without","With")
6 Replies
Hi Abdel-2024
= IF ( Table1[Opp_ID] IN Table2[LOA_ID], "With", "Without" )Hi, Thanks but still it is not working
1st both columns contains text
2nd same text (string) is repeated in several rows in each column
sOpportunity_ID
22.KE.301258 22.KE.301258 22.KE.301258 22.KE.301258 22.KE.301258 22.KE.301258 22.TZ.293595 22.TZ.304520 22.TZ.293595 22.TZ.293595 22.TZ.293595 22.TZ.293595 LOA_ID
22.KE.301258 22.TZ.293595 22.TZ.304520 22.TZ.293595 22.KE.301258 22.KE.301258 Oh! my mistake. Please try
= IF ( Table1[Opp_ID] IN VALUES ( Table2[LOA_ID] ), "With", "Without" )
