Forum Discussion
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: Filte...
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
amitchandakunderstood. Thanks for your explanation. This worked perfectly