https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-query-help/m-p/1118025#M16395 <P>I have two measures --</P><P>active customers gross:=</P><P>CALCULATE(DISTINCTCOUNT(sales_order_item[id_customer]),sales_order_item[status_code]&gt;=1)</P><P>new customer gross:=</P><P>CALCULATE(DISTINCTCOUNT(sales_order_item[id_customer]),sales_order[order_rank]=1,sales_order_item[status_code]&gt;=1)</P><P><BR />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...</P><P>repeat customer = active customer- new customer</P><P>but i just dont want repeat customer from active customer, i want repeat customer from last month's new customer..</P> Mon, 25 May 2020 14:04:58 GMT Anonymous 2020-05-25T14:04:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-query-help/m-p/1118025#M16395 <P>I have two measures --</P><P>active customers gross:=</P><P>CALCULATE(DISTINCTCOUNT(sales_order_item[id_customer]),sales_order_item[status_code]&gt;=1)</P><P>new customer gross:=</P><P>CALCULATE(DISTINCTCOUNT(sales_order_item[id_customer]),sales_order[order_rank]=1,sales_order_item[status_code]&gt;=1)</P><P><BR />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...</P><P>repeat customer = active customer- new customer</P><P>but i just dont want repeat customer from active customer, i want repeat customer from last month's new customer..</P> Mon, 25 May 2020 14:04:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-query-help/m-p/1118025#M16395 Anonymous 2020-05-25T14:04:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-query-help/m-p/1118088#M16399 Anonymous</LI-USER> - You want New and Returning Customers: <A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/New-and-Returning-Customers/td-p/168297" target="_blank">https://community.powerbi.com/t5/Quick-Measures-Gallery/New-and-Returning-Customers/td-p/168297</A><BR /><BR />And please try not to cross post. Mon, 25 May 2020 15:05:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/dax-query-help/m-p/1118088#M16399 Greg_Deckler 2020-05-25T15:05:23Z