Forum Discussion

RaquelSantos_PT's avatar
RaquelSantos_PT
New Member
4 years ago

Calculate the previous segment

Hello,   I have a model with a RFM Segmentation, that is calculate for the period select. However, now I would like to select a period, and calculate the last segment for those customers, what I w...
Need Help
RaquelSantos_PT's avatar
RaquelSantos_PT
New Member
4 years ago

Hello amitchandak ,

 

right now I calculate the RFM segment as a measure with the following code:

 

Clientes_RFM =
var vToday = max('calendar'[date])
Var vResult = CALCULATE('Cliente PT'[# Clientes],
filter(VALUES('Dados OMS PT'[email]),
[# Encomendas]>=min(Aux_RFM_Freq[Lim_Inf]) &&
[# Encomendas]<=max(Aux_RFM_Freq[Lim_Sup]) &&
[Cesta]>min(Aux_RFM_Monetary[Lim_Inf]) &&
[Cesta]<=max(Aux_RFM_Monetary[Lim_Sup]) &&
DATEDIFF([Ultima_Compra],vToday,DAY)>=min(Aux_RMF_Recency[Lim_Inf]) &&
DATEDIFF([Ultima_Compra],vToday,DAY)<=max(Aux_RMF_Recency[Lim_Sup])
))
return vResult
 
and I also have auxiliary tables to define the limits of the segments: 
 

 

I didn't understand how can calculate the segment of each customer by month.

Can you help me please?

 

Thank you,

Raquel