New lost an return customers

[0031642595090]

I have data that contains customer numbers, purchase dates, number of orders and total sales. I want to count the new customers who 1x buying withinen last 8 weeks, and the Count of customers who bought 4 times within the last 8 weeks, the count of lost customers who did not buy in the past 8 weeks, and the count of customers who returned to purchase. Please help me 

power bi. Thanks alot

 

 

 

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.  Ensure there is a Calendar table there with a column of Week numbers.

[PabloDeheza]

Hi there!

This might be helpful!

https://www.daxpatterns.com/new-and-returning-customers/

[0031642595090]

I try it but doesnt work at all

It give blank voor all results

[grantsamborn]

Its pretty tough without data to work with but this might help.

I know there is probably better ways to do it (ie. fewer measures) but it seems to work with my random sales data.

Also, I wasn't sure how Returns were being handled so I didn't address that.

pbix: https://1drv.ms/u/s!AnF6rI36HAVkhPFTKTS_TW-6-QOo9A?e=r022Cd

I hope this helps.