Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
SLima
Helper I
Helper I

Customers do not buy "x" Months (parameter)

I created this measure to select customers who are not buying at "x" (parameter) month.

it's not working.

 

measure =
VAR vParametro=ParamMeses[ParamMeses Valor]
VAR _Data = MIN(dCalendarioCliente[Date])
VAR Mes_Anterior = EDATE(_Data, vParametro)
VAR Clientes_Compraram_Mes_Atual =
VALUES(fVendasProduto[IDCLIENTE])
VAR Clientes_Compraram_MesParam =
CALCULATETABLE(
VALUES(fVendasProduto[IDCLIENTE]),
dCalendarioCliente[Date] < _Data &&
dCalendarioCliente[Date] >= Mes_Anterior
//DATEADD(dCalendarioCliente[Date],vParametro,MONTH)
)
VAR _Except =
EXCEPT(Clientes_Compraram_Mes_Atual,Clientes_Compraram_MesParam )
VAR Resultado =
CALCULATE(
[Total de Vendas Analise Clintes],
KEEPFILTERS(_Except)
)
RETURN
Resultado

Thanks in advance.

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@SLima , Try a measure like

 

measure =
VAR vParametro=ParamMeses[ParamMeses Valor]
VAR _max = MAXX(allselected(dCalendarioCliente),dCalendarioCliente[Date])
VAR _min = date(year(_max), month(_max) -1* vParametro, 1) 4
var _m1 =calculate([Total de Vendas Analise Clintes], filter(dCalendarioCliente, dCalendarioCliente[Date] >=_min && dCalendarioCliente[Date] <=_max))
return
countx(VALUES(fVendasProduto[IDCLIENTE]), if(isblank(_m1), [IDCLIENTE], blank()))

 

 

Does not work.
I need it to show only customers who didn't buy x (parameter) month last.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors