Forum Discussion
Anonymous
6 years agoNot applicable
dax query help
I have two measures --
active customers gross:=
CALCULATE(DISTINCTCOUNT(sales_order_item[id_customer]),sales_order_item[status_code]>=1)
new customer gross:=
CALCULATE(DISTINCTCOUNT(sales_order_item[id_customer]),sales_order[order_rank]=1,sales_order_item[status_code]>=1)
i want a dax query to find the new customer behaviour.. a customer who is new for month of january 2020, whether he had purchased anything on next mont month (feb 2020)...so basically i want to find the how many new customers from january have became active customers in february...
repeat customer = active customer- new customer
but i just dont want repeat customer from active customer, i want repeat customer from last month's new customer..
1 Reply
- Greg_Deckler
Community Champion
Anonymous - You want New and Returning Customers: https://community.powerbi.com/t5/Quick-Measures-Gallery/New-and-Returning-Customers/td-p/168297
And please try not to cross post.