hi

[abc_777]

Hello,

I am trying to do RFM - Recency, Frequency, Monetary of customer

most of people use percenrank.exc in excel formula. 

can some one help me how can i use percenrank.exc in power bi as its not in power bi. or how can i do RFM in powr bi

thanks

[foodd · Accepted solution]

Senelwa Dudayev in his July 2023 Medium article, walks you through Customer Segmentation with RFM Analysis including a description of the RFM Model, RFM Score, and DAX measure samples.

RFM and Customer Segmentation Analysis in Power BI