Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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..