first time customer orders product

Question

Hello,&nbsp;How do I build a report that finds out when a customer&nbsp;orders a new product that they haven't purchased before&nbsp;hypothetical simple example below:&nbsp;The supplier has the following items to sell:&nbsp;spinach code 456apples&nbsp;&nbsp; code&nbsp; 331lettuce&nbsp; code&nbsp;&nbsp;222oranges code 321cherries code 385&nbsp;A customer usually&nbsp;orders&nbsp; the below:&nbsp;spinach code 456apples&nbsp;&nbsp; code&nbsp; 331lettuce&nbsp; code&nbsp;&nbsp;222&nbsp;&nbsp;However a customer suddenly starts ordering an item they have never ordered before:&nbsp;cherries code 385&nbsp;&nbsp;How could I build a report or to capture the first time this customer ordered Cherries code 385?&nbsp;Thank you for your help!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

v-frfei-msft · Accepted Answer

Hi&nbsp;spud,&nbsp;I made a sample like this and create two measures to meet your requirement.&nbsp;maxdate = IF( MAX('VALUE'[DATE])=CALCULATE(MAX('VALUE'[DATE]),ALL('VALUE')),1,0)Measure = CALCULATE(COUNT('VALUE'[client]))&nbsp;&nbsp;Here I create the visuals like this, in the visual level filters we need to make maxdate and measure is 1 in both tables visuals. Then we can easily find that A puchase a new product on 2018/02/02.&nbsp;&nbsp;&nbsp;For more details. please check the pbix as attached. If it doesn't meet your requirement, kindly share excepted result to me.&nbsp;https://www.dropbox.com/s/9m2aiois8hfaoh5/first%20time%20customer%20orders%20product.pbix?dl=0&nbsp;Regards,Frank

Forum Discussion

first time customer orders product

2 Replies

Related content

slicer custom order

Calculate follow up orders by product

Segmentation based on Product List available for each Customer

V-Order & Z-Order

Average Days to Order by Year and Product with Customer Count