Creating a new table with a cartesian product column
I am trying to create a new table containing every combination of Product in within one transaction id. So if transaction 1 contained 3 different products, that would be 3 x 3 = 9 combinations. This needs to be done in DAX.
The input is this:
The expected output is this, where Product 1 and Product 2 show every combination of product in that Transaction id.