First product bought - cohort

Question

HI,&nbsp;I have the next table:Customer Id - rank* - Order Id - SKU&nbsp; &nbsp;1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;- 7894&nbsp; &nbsp; &nbsp; &nbsp; - SKU 1&nbsp; &nbsp;1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;2&nbsp; &nbsp; &nbsp;- 7856&nbsp; &nbsp; &nbsp; &nbsp; - SKU 2&nbsp; &nbsp;1456&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;- 7676&nbsp; &nbsp; &nbsp; &nbsp; - SKU 1&nbsp; &nbsp;1456&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;2&nbsp; &nbsp; &nbsp;- 7906&nbsp; &nbsp; &nbsp; &nbsp; - SKU 3&nbsp; &nbsp;1789&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;- 7236&nbsp; &nbsp; &nbsp; &nbsp; - SKU 5&nbsp; &nbsp;1906&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;- 7576&nbsp; &nbsp; &nbsp; &nbsp; - SKU 2* rank is based on purchase date.&nbsp;&nbsp;I want to have a column that will show the first SKU that this customer bought. Like:Customer Id - rank - Order Id - SKU&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -&nbsp; FIRST SKU&nbsp;&nbsp; &nbsp;1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; - 7894&nbsp; &nbsp; &nbsp; &nbsp; - SKU 1&nbsp; &nbsp; &nbsp; &nbsp;-&nbsp;SKU 1&nbsp;&nbsp;&nbsp; &nbsp;1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;2&nbsp; &nbsp; - 7856&nbsp; &nbsp; &nbsp; &nbsp; - SKU 2&nbsp;&nbsp; &nbsp; &nbsp; -&nbsp;SKU 1&nbsp;&nbsp;&nbsp; &nbsp;1456&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; - 7676&nbsp; &nbsp; &nbsp; &nbsp; - SKU 5&nbsp;&nbsp; &nbsp; &nbsp; -&nbsp;SKU 5&nbsp;&nbsp;&nbsp; &nbsp;1456&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; - 7676&nbsp; &nbsp; &nbsp; &nbsp; - SKU 2&nbsp;&nbsp; &nbsp; &nbsp; -&nbsp;SKU 5&nbsp;&nbsp;&nbsp; &nbsp;1456&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;2&nbsp; &nbsp; - 7906&nbsp; &nbsp; &nbsp; &nbsp; - SKU 3&nbsp;&nbsp; &nbsp; &nbsp; -&nbsp;SKU 5&nbsp;&nbsp;&nbsp; &nbsp;1789&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; - 7236&nbsp; &nbsp; &nbsp; &nbsp; - SKU 5&nbsp;&nbsp; &nbsp; &nbsp; -&nbsp;SKU 5&nbsp;&nbsp;&nbsp; &nbsp;1906&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; - 7576&nbsp; &nbsp; &nbsp; &nbsp; - SKU 2&nbsp;&nbsp; &nbsp; &nbsp; -&nbsp;SKU 2&nbsp;&nbsp;In case if one order (like 7676) have few SKU, any SKU can be choose.&nbsp;Thanks!!

v-piga-msft · Accepted Answer

Hi&nbsp;juli__sia123412&nbsp;,
You could try the calculated column below.
Column =
CALCULATE (
    MAX ( 'Table1'[SKU] ),
    FILTER (
        'Table1',
        'Table1'[Rank] = MIN ( 'Table1'[Rank] )
            &amp;&amp; 'Table1'[Customer ID] = EARLIER ( Table1[Customer ID] )
    )
)

Here is the output.

Best&nbsp; Regards,
Cherry
&nbsp;

Forum Discussion

First product bought - cohort

1 Reply