topic Re: DAX command in DAX Commands and Tips

DAX command

Abdel-2024 — Wed, 10 May 2023 10:23:29 GMT

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

Re: DAX command

tamerj1 — Wed, 10 May 2023 11:10:09 GMT

Hi Abdel-2024

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

Re: DAX command

Abdel-2024 — Wed, 10 May 2023 12:25:39 GMT

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

22.TZ.304520

22.TZ.293595

LOA_ID

22.KE.301258

22.TZ.293595

22.TZ.304520

22.TZ.293595

22.KE.301258

Re: DAX command

tamerj1 — Wed, 10 May 2023 12:31:07 GMT

Abdel-2024

Oh! my mistake. Please try

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

Re: DAX command

Abdel-2024 — Wed, 10 May 2023 13:23:43 GMT

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

Re: DAX command

tamerj1 — Wed, 10 May 2023 13:35:01 GMT

Abdel-2024

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

Re: DAX command

Abdel-2024 — Wed, 10 May 2023 13:42:11 GMT

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"