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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
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

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

    Thanks! You rock.