first time customer orders product

[spud]

Hello,

How do I build a report that finds out when a customer orders a new product that they haven't purchased before

hypothetical simple example below:

The supplier has the following items to sell:

spinach code 456

apples   code  331

lettuce  code  222

oranges code 321

cherries code 385

A customer usually orders  the below:

spinach code 456

apples   code  331

lettuce  code  222

However a customer suddenly starts ordering an item they have never ordered before:

cherries code 385

How could I build a report or to capture the first time this customer ordered Cherries code 385?

Thank you for your help!

[v-frfei-msft · Accepted solution]

Hi @spud,

I made a sample like this and create two measures to meet your requirement.

maxdate = IF( MAX('VALUE'[DATE])=CALCULATE(MAX('VALUE'[DATE]),ALL('VALUE')),1,0)

Measure = CALCULATE(COUNT('VALUE'[client]))

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.

 

For more details. please check the pbix as attached. If it doesn't meet your requirement, kindly share excepted result to me.

https://www.dropbox.com/s/9m2aiois8hfaoh5/first%20time%20customer%20orders%20product.pbix?dl=0

Regards,

Frank

[v-frfei-msft]

Hi @spud,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank