Flag based on data in other rows

[Anonymous]

Hello

I'm giving this another go because the solution provided wasn't really clear and didn't articulate for me customizable fields (Caution: I am green in this space so I would need step-by-step or a screen image of the DAX function you write so i can try to mimic using my real data)

I have a basic dataset like this

CustomerID	ProductID
11111	A
22222	C
33333	A
22222	C
44444	A
66666	A
55555	B

What I'm trying to do is to add a column that will flag other purchases that this same customer made elsewhere in the table, so I want my final dataset to look like this

CustomerID	ProductID	ProductAFlag	ProductBFlag	ProductCFlag
11111	A	Y	N	N
22222	C	Y	N	Y
33333	A	Y	N	N
22222	A	Y	N	Y
44444	A	Y	Y	N
66666	A	Y	N	N
44444	B	Y	Y	N

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

All DAX forluma for creating calculated columns are in the attached pbix file.