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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors