Customer Segmentation

[Milan14]

Hi everyone,

I would like to calculate 

Q1. how many user been visit the store for {2-4 times, 5-7 times, 8 times and above};

Q2. how many user been spend for {RM100 and below, RM101-RM300, RM301 and above};

on the last 3 months, last 6 months and last 9 months.

Variable created:

Last 3 months: EOMONTH(TodayDate, -3)

Last 6 months: EOMONTH(TodayDate, -6)

Last 9 months: EOMONTH(TodayDate, -9)

Date Outcome:

Last 3 months: From 1 December, 2022 until yesterday

Last 6 months: From 1 September, 2022 until yesterday

Last 9 months: From 1 June, 2022 until yesterday

Sample Data:

Expected Outcome:

Does anyone have any ideas what kind of formula I should apply?

Any help would be much appreciated.

Thanks in advance!

Kindly Regards,

Milan

[Milan14]

Hi @Jihwan_Kim,

Thanks for your help, it's exactly what I need !

Regards,

Milan

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

I hope the below can provide some ideas on how to create a solution for your datamodel.

All measures are in the attached pbix file.