Customer RFM Analysis in Power BI - Recency, Frequency, Monetary

RFM analysis is a marketing technique used to quantitatively rank and group customers based on the recency, frequency, and monetary value of their transactions.

The goal is to identify the best customers and perform targeted marketing campaigns.

Please find the DAX code and the Segmentation table in the first comment.

==Chapters==
1:17 Segment Scores Table
2:17 scanner_data Table (transactional table)
2:39 Calendar Table
2:51 Data Model Relationships
3:25 Creating the Measures
4:46 Create the RFM Table
5:15 Calculate the Scores in the RFM Table

#powerbi #powerquery #dataanalytics #datamodeling

[Data.Analytics.Central]

The DAX code and the Segmentation table:

[NikitaShilyaev]

Your M score formula is just the same as F score formula 6:16

[KamZardouzian]

Hi, thanks for the video. Very helpful. The M Score formula should have [M Value} instead of [F Value]. I think this is causing a lot of the issues other people are having.

[tinhhoang]

thank you so much for sharing this knowledge <3

[Mamadhaifa]

how do we create the rfm chart if we have the value all sorted out

[habibaidara]

Hello sir I need your
In fact when I do the pythpn implementation I have all the segments, but with power bi I have 7 segments
I have the same chosen in power with what you are doing.
Can you know the problem?

[raniasaleh]

Hi Viorel, first, thank you for sharing your precious videos and for your detailed clarification, however, In this video, I couldn't get how you segment customers into 11 categories. Thank you in advance for your assistance.

[ryanenoch]

Hi
At 4:30, I noticed for getting M value you are dividing sum of sales by sum of quantity. Why is that? Can't we just sum the sales amounts for each customer to get the highest contributing customer?

PS: Can you provide a link to the dataset?

Thanks

[NyHuỳnh-ci]

Thank you so much!
Can you share how to create SegmentScores table?

[FooMengNg]

Hey man, I used the data and the given DAX code, I ended getting all the RFM = 555 why is that so in the RFM Table? is there something wrong with the DaX code?

[owenagitza]

Thanks for your explanation!
Where can I access the scanner_data table (if that's possible)?

[maggiechan]

am i know why when i typed in teh RFM table it pop up msg - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. What can i do?

[GemmaJohsnon]

Thank you, this has been very helpful. I will be using live data from our CRM system, is there a way I can track the changes to the RFM score as customers place more orders? Thank you

[johndoe-onrt]

Hello and first of all: Thanks a lot for your great videos & useful content. You've got a new subscriber! I am struggling at minute 5:00 because if I use this DAX formular (for sure with my table names and columns instead of scanner_data) I receive the following error message: "The expression references multiple columns. Multiple columns cannot be converted to a scalar value." Any ideas whats my mistake? Anyway, I will try further to find my mistake. Many thanks again and all the best to you!

Update: My mistake :) I created a new measure in "RFM table" instead of updating the table. Anything is fine, so thanks again for your great content! Best

[marjorielawman]

Harris Helen Williams Sandra Brown Scott