Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

basket analysis

HI, I need help with the following dax.

 

I have a table (store name, date, customer ID, bought item , price etc...)

To do a basket analysis, I created a second table with following DAX:

 

Filter ( Crossjoin ( Values ( 'POS' [Item]), Selectcolumns ( Values ( 'POS' [Item]), "Item2", [Item] )), [Item] > [Item] )

 

This works fine, but I would like to add, [store name] and [ year-month] .

 

How can I modify the above Dax that it will contain these two columns?

 

Thanks for your help

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous ,

    You can have like this

    Filter ( Crossjoin ( Values ( 'POS' [Item]), Selectcolumns ( 'POS', "Item2", [Item], "store name" , [store name]," year-month",[ year-month] )), [Item] > [Item] )

     

     

    Cross join do not take same column name, select columns is used to restrict /rename columns

     

    You can take full tables too.

    crossjoin(table1,Table2)

    both can have selectcolumns

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandakunderstood. Thanks for your explanation. This worked perfectly