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...
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.==
Are you creating a calculated column or a measure? My code is supposed to be a claculated column.
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"