dax query help

[nsatyabrat7]

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

[Greg_Deckler]

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