New Customer

[SofiaTeles]

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)