DAX FORMULA FOR PRODUCTS TABLE

[kyriakos]

Hi Everyone,

So i have the data below (part of it). What the table shows are products purchased by each customer. Order ID may appear more than once (that is why a created a UNIQUE column, that concatenates ORDER ID, DATE and STORE ID). What i want to do is to create a column, that shows what other products were purchased by a customer. To be more specific (as shown in the table below), i have the same order ID appearing 3 times (this is one unique purchase as on 1st of May). Customer purchased 3 items (quantities differ) - Item Code 9350 (quantities 2) and item code 9100 (quantities 1 and 1). What i want to do is to have a column that returns the below:

If product 9350 was purchase, the customer also purchased product 9100 (quantities).

How is this possible?

Many thanks

[Anonymous]

Hi @kyriakos 

Can you provide a complete sample that can show all your tables and the relationships between them . From the information you have provided so far, there is no way to create the columns you need .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.