help! measure for new sales from existing customers

[kirko]

Hi Everyone

I have only a basic working knowledge of DAX, but managed to cobble things together over the last few months.

I have a dataset of customers, and for each month I need to calculate:

1. Sales from new customers (customers who were not in the database last month)

2. New sales from existing customers

3. Lost sales from existing customers

4. Sales from lost customers

I have used quick measure for number 1, and hav been trying to ammend that code for the others but am struggling to create for the others. can anyone help?

[v-yuezhe-msft]

@kirko,

Please share dummy data of your table and post expected result based on the data you post.

Regards,
Lydia