Compare two columns inside same table and result with Yes or No

[Anonymous]

Hi,

I am trying to do a basic VLOOKUP between two columns and the result should be YES or NO. This is easily possible in Excel. Need your help in Power BI.

I have a two columns as shown below Ticket ID and Problem ID. I would like to search the Ticket ID in the Problem ID column (If it exists anywhere in Problem ID column). If yes then we need a new third column like below which should say Yes / No for Ticket ID column.

I want this resultant third column inside the same Table and not as a new calculated table. Need your help please

Ticket ID	Problem ID	Yes / No
1	1	Yes
2		No
3		Yes
4	3	No
5		Yes
6	5	No

[ryszardre]

The formula above doesn't work! Look at the marked rows:

@v-yulgu-msft - could you please verify and help?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

New a calculated column with below DAX:

Yes/NO = IF(LOOKUPVALUE(Table2[Problem ID],Table2[Problem ID],Table2[Ticket ID])=BLANK(),"No","Yes")

Best regards,

Yuliana Gu