Active and Inactive customer

[kasiaw29]

Hi there,

I'm looking to create a custom column that evaluates customer orders and determines if the customer is active/reactivated/inactive. 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. 

Reactivated are those that have been unactive (haven't placed orderes in last 12 months) but suddenly placed orders. 

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: 

Invoiced in Last 12M =

CALCULATE(

SUM('Customer Orders'[Total Invoiced Value]),

DATESINPERIOD('Customer Orders'[Invoice Date].[Date],MAX('Customer Orders'[Invoice Date]),-12,MONTH))

Any help is truly appreciated. 

[amitchandak · Accepted solution]

@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

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/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

Does the above reply helps. if you need more help make me @

Appreciate your Kudos.