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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
SofiaTeles
Frequent Visitor

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)

 

 

 

0 REPLIES 0

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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