Forum Discussion

Wkeith's avatar
Wkeith
Icon for Helper II rankHelper II
7 years ago
Solved

Duplicate Concatenate Question

Hi, I am trying to concatenate products that belong to the same order ID to do some market basket analysis. So for example, lets say for an order number that has these products sold in it: Milk, Brea...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Wkeith ,

     

    Try to change you formula to something similar to this:

     

    Market Basket =
CALCULATE(
CONCATENATEX(DISTINCT(Sales[Product]), Sales[Product], “-“ ),
FILTER(
ALL(Sales),
Sales[Transaction ID] = EARLIER(Sales[Transaction ID])
)
)

    Regards,

    MFelix