DAX command

[Abdel-2024]

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")

[tamerj1]

Hi @Abdel-2024 

=
IF ( Table1[Opp_ID] IN Table2[LOA_ID], "With", "Without" )

[Abdel-2024]

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

[tamerj1]

@Abdel-2024 

Oh! my mistake. Please try

=
IF ( Table1[Opp_ID] IN VALUES ( Table2[LOA_ID] ), "With", "Without" )

[Abdel-2024]

still not working I belive we need to use the following DAX formula , however it gives me below error although there is link between the 2 tables The column

IF(ISBLANK(LOOKUPVALUE( CSP_Automation[QC number],CSP_Automation[QC_Opp_ID],RELATED(WBSMapping[Opportunity_ID]))),"with")

=='WBSMapping[Opportunity_ID]' either doesn't exist or doesn't have a relationship to any table available in the current context.==

[tamerj1]

@Abdel-2024 

Are you creating a calculated column or a measure? My code is supposed to be a claculated column.

[Abdel-2024]

I need to create new column to check/lookup if the text in Opp_ID column (Table1) is existing  in LOA_ID column in Table2 , if yes it will return "with" if not return "witout"