Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

fram09

RFM analysis

Submitted by on ‎04-11-2023 01:43 AM

Hi Everyone, 

If we have a dataset of 1000 customers in three years from 2020 to 2022. for the Customer segmentation report in October 2022, do we have to run RFM for all 1000 of data and then report customer segments that have a transaction in October 2022, or first filter down the dataset for October 2022 and run RFM for that one month?

I hope anyone can make this clear to me, thanks.

 

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎04-11-2023 11:28 PM

Hi @fram09 

I found some relevant content, I hope it will help you .

Using DAX for Customers Segmentation by RFM: Recency, Frequency and Monetary Value - Power BI Experi...

RFM model for customer segmentation - Microsoft Power BI Community

RFM Analysis for Customer Segmentation with Power BI | by Ploii Tubsamon | Medium

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses