How to concatenate a list of products by customer (product combos)

[danielgnic]

Hello, I have of list of transactions by customers like this:

I need to figure out the combinations of products by customer, something like this:

Also, I would like to be able to filter these product combos considering just customers who bought product "A" or product "A" and other.

Finally, I expect to have a visualization with this information:

Top product combos is the frequence in which a customer buys "A,B".

Thank you in advance 🙂

[danielgnic]

Hello @v-zhangti , thank you for your reply.

Your formula did work, however, I have something like this:

I would like to be able to filter by transaction type and also by date:

This example shows just transactions that are "REGISTER". I'd like to the the same but with dates (for example, I'd like to see just data between march 10th and march 12th).

Finally, I'd like to get the frequence that I have per list or product combo, for example:

Consider as well than I'm trying to filter from the beginning customers that bought product "A" and some other product. 

Thank you in advance 🙂

[v-zhangti · Accepted solution]

Hi, @danielgnic 

You can try the following methods.
Column:

Product List = 
CONCATENATEX (
    CALCULATETABLE ( VALUES ( 'Table'[Product] ),
        FILTER ( ALL ( 'Table' ),
            [Transaction Type] = EARLIER ( 'Table'[Transaction Type] )
                && [Customer ID] = EARLIER ( 'Table'[Customer ID] ) ) ),
    [Product],
    ","
)

Measure:

FREQENCE = CALCULATE(DISTINCTCOUNT('Table'[Customer ID]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-zhangti]

Hi, @danielgnic 

You can try the following methods.

New Table = 
SUMMARIZE ( 'Table','Table'[Customer ID],
    "Product Combo", CONCATENATEX ( VALUES ( 'Table'[Product] ), [Product], "," )
)

Can you provide more sample data to explain the logic of the last graph?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.