Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

RFM Model - How to create a Cluster Record to visualize evolutiong throught time?

Hello Everyone!! I created some sort of a Cluster usind the RFM Model (Recency, Frequency, Monetary) directly in a calculed collumn, so with that I can have the name of the cluster for each one of m...
General Comment
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hey MFelix 

Thank you very much for your help, I sent a mock up file just to understand the solution, but actually there is others parameters to identify a cluster. I just did not understand the Cluster Count part, I am sharing another power bi file with you, with all the parameters that actually counts. 

Just for you to follow, I have the recency note, the frequency note and other parameters like (first date order, amout of orders) that I used IF Conditional to create each one of the clusters inside the Clients Table.

Would you mind to have a look at this new file, it has the same idea, but it is a bit more complex.

Thank you very much in advance.

I saw that you come from Portugal, this other file is in Portuguese, because actually this file comes from Brazil haha

Please let me know if you can understand the tables, the measures and the calculated columns

https://drive.google.com/file/d/1oTaTjwouSF46nYiAxzeq3L5ueiirrgzI/view?usp=sharing 

MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

Big file, I will have a look at it and will get back to you ASAP.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    MFelix thank you very much!!

    I think it will be a bit harder to come up with a solution because there are actually too many variables to determinate all the clusters