technolog
Super User
Super UserRFM-analysis
An RFM analysis was built, where data about our clients are arranged in the form of one summary table, where are indicated: RFM client segment, date of his last purchase, number of purchases, and amo...
Hello,
I'm practicing RFM analysis on my dataset with 18K customers. I got the performance issue as my segment calculation using DAX has exceeded the available resource of Power BI.
So I'm curious about how you calculate RFM score. Could you please share me what you did on the calculation? For example, how does RFM score link to the Year filter at the top of dashboard? What happens if I select year 2022? Is it like the dashboard will filter to get all customers that have last transaction in 2022, and only calculate and visualise data from those customers?
One more question, for R, F and M score, do you use calculated column to calculate?
Thank you in advance!
