Custom Column For Matching Values

[radonwilson]

1. In Trans_Type Col, I have 3 transaction types i.e. Order, Shipping Services & Refund.
2. Now, some Order_IDs of Order (Trans_Type) are matching with Refund (Trans_Type), I want to tag these matched as "Found" and the rest as "Unfound" in Custom Column.

How to create a custom column in a power query?

Demo.xlsx
	A	B	C
1	Trans_Type	Order ID	Helper/Custom Column
2	Order	111	Not Found
3	Shipping Service	111	Not Found
4	Refund	999	Found
5	Shipping Service	222	Not Found
6	Order	222	Found
7	Order	333	Not Found
8	Order	444	Not Found
9	Order	555	Found
10	Order	666	Not Found
11	Order	777	Found
12	Order	888	Not Found
13	Order	999	Found
14	Refund	777	Found
15	Shipping Service	333	Not Found
16	Shipping Service	444	Not Found
17	Shipping Service	555	Not Found
18	Shipping Service	999	Not Found
19	Refund	222	Found
20	Refund	555	Found
21	Refund	2121	Not Found
22	Shipping Service	666	Not Found
23	Shipping Service	777	Not Found
24	Shipping Service	888	Not Found
25	Refund	4242	Not Found
26	Refund	3939	Not Found
27	Refund	5757	Not Found
Sheet1

 

[radonwilson]

I am already following his playlist, he is fantastic.

One of the best PQ tutorials is a full college level class - Full Advanced Data Analysis & BI Class (MSPTDA). Power Query. I highly recommend it. It's currently 83 videos, and nearly all have start and end workbook samples to download as well as data and PDFs as needed. The channel is amazing. Don't be fooled by how old the videos are, they still teach the basic and even high level skills needed for PQ. You might want to check out the channel itself. Mike is one of the best with PQ that I've seen