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)
