Active and Inactive customer

Question

Hi there,&nbsp;I'm looking to create a custom column that evaluates customer orders and determines if the customer is active/reactivated/inactive.&nbsp;Has anyone completed anything like this to date? Any previous articles that you know that cover this?Active customers are defined as those who have ordered in last 12 months.&nbsp;Reactivated are those that have been unactive (haven't placed orderes in last 12 months) but suddenly placed orders.&nbsp;&nbsp;I do have a measure in already to find those that have invoiced in the last 12 months but now I'm looking to see to analyse their behaviour change overtime. My measure is like this:&nbsp;Invoiced in Last 12M = CALCULATE(SUM('Customer Orders'[Total Invoiced Value]),DATESINPERIOD('Customer Orders'[Invoice Date].[Date],MAX('Customer Orders'[Invoice Date]),-12,MONTH))&nbsp;Any help is truly appreciated.&nbsp;

amitchandak · Accepted Answer

kasiaw29 , Not invoiced in last 12 month 
if(isblank([Invoiced in Last 12M]),1,blank())
This will customer those do not purchsed in last 12 month
&nbsp;
Refer my two blogs on the same topics
Customer Retention Part 1:https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458
&nbsp;
Does the above reply helps. if you need more help make me @Appreciate your Kudos.

Forum Discussion

Active and Inactive customer

1 Reply

Related content

relationship active & inactive

Active & Inactive customers

Active and Inactive Relationship - Display Chart on Inactive Relationship

Creating ICMs via Activator

Activity Statistics