Forum Discussion

SofiaTeles's avatar
SofiaTeles
Frequent Visitor
3 years ago

New Customer

HI every one, 

 

I'm returnig to dax after a few years without using it so I really aprettiate your help. 

 

I'm using the function bellow in order to  knhow many new orders (ie, orders from new clients) I have over time (for instance, each month). However, the function is returnin the number of order by month that were not made by the same customer. That is not what I want. I want to now how many new customer do I gather each month.

 

In may data base, in orther to consider clients that acctually have purchase I have to add a condition that is: t_ListaPagamento[Estado do Pagamento]="Pago".

 

Do you have any idea on how I can improve this code? 

 

Thanks in advance, 

Sofia

 

___________

New Orders =

VAR currentCustomers = CALCULATETABLE(VALUES(t_ListaPagamento[Email]),t_ListaPagamento[Estado do Pagamento]="Pago")

VAR currentDate = MIN(t_ListaPagamento[Data])

VAR pastCustomers = CALCULATETABLE(VALUES(t_ListaPagamento[Email]),
    ALL(t_ListaPagamento[Data].[Mês] ,t_ListaPagamento[Data].[MonthNo],t_ListaPagamento[Data].[Ano])
    , t_ListaPagamento[Data]<currentDate)

VAR newCustomers = EXCEPT(currentCustomers,pastCustomers)

RETURN COUNTROWS(newCustomers)

 

 

 

Need Help
No RepliesBe the first to reply