Forum Discussion

Frequent Visitor

3 years ago

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...

Community Champion

3 years ago

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

Abdel-2024
Frequent Visitor
3 years ago
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
  Community Champion
  3 years ago
  Abdel-2024
  
  Oh! my mistake. Please try
  
  = IF ( Table1[Opp_ID] IN VALUES ( Table2[LOA_ID] ), "With", "Without" )
  - Abdel-2024
    Frequent Visitor
    3 years ago
    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.==