Forum Discussion

NazaCingolani's avatar
NazaCingolani
New Member
3 years ago
Solved

Calculating New Table for Product Combos

So, here is a sample dataset of how my Sales Table is: Sales Table: What I need to do, is understand which are the most common "product combinations" based on this table. An example of the ...
Need Help
Tips and Tricks
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Ah okay,

     

    try this one:

    I've highlighted the only change to the calculated column

    Column =
    CONCATENATEX (
        CALCULATETABLE (
            ADDCOLUMNS('Table (2)',"Product",'Table (2)'[Product Type]),
            ALLEXCEPT ( 'Table (2)', 'Table (2)'[Order ID] )
           
        ),
        [Product Type],
        " & ",
        [Product Type],ASC
    )
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

     
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Ah okay,

 

try this one:

I've highlighted the only change to the calculated column

Column =
CONCATENATEX (
    CALCULATETABLE (
        ADDCOLUMNS('Table (2)',"Product",'Table (2)'[Product Type]),
        ALLEXCEPT ( 'Table (2)', 'Table (2)'[Order ID] )
       
    ),
    [Product Type],
    " & ",
    [Product Type],ASC
)
 
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 
NazaCingolani's avatar
NazaCingolani
New Member
3 years ago

Amazing. It worked like a charm!

One final thing. If I would like to exclude a product from this formula, where should the filter be applied/hardcode?