At this moment, I would need help with a DAX formula related to grouping customers based on the frequency of purchase (how many months a customer buy in a Year), instead of total sales. I have been reviewing many of your videos trying to learn as much as possible about this topic, but I did not find the answer I’m looking for.
The scenario I’m dealing with is as follows:
The company wants to group their customers based on the following criteria:
Consistent Customers = Buying 11 or 12 months within a12 month period prior.
Frequent Customers = Buying 8, 9 or 10 months within a12 month period prior.
Recurring Customers = Buyiing 5, 6 or 7 months within a12 month period prior.
Occasional Customers = Buying 2, 3 or 4 months within a12 month period prior.
Sporadic Customers = Buying just 1 month within a12 month period prior.
I appreciate if you can help me with this.
Thanks in advance for your reply