Clients who haven't sent orders for more than 3 months

[frostys]

Hi !

I try to make a DAX function to show clients who have no sent any orders for more than 3 months.

With this kind of data :

Thank you for your help 

[Phil_Seamark]

Hi @frostys

How can we tell which is a client?

[frostys]

The order number is related to a clients name and client code, I forget to mention that sorry !

[Phil_Seamark]

Hi @frostys

This calculated table will give you a list of your customers

Table = 
VAR CustomersPurchasedLast3Months = 
        SELECTCOLUMNS(
            FILTER(
                'Table2',
                EOMONTH('Table2'[Date],3)>TODAY()
                ),
            "Customer",[Controlling Customer Name])

RETURN EXCEPT(
            VALUES('Table2'[Controlling Customer Name]),
            CustomersPurchasedLast3Months
            )   

[frostys]

Thank you for you respond ! @Phil_Seamark

I created this formula but I try to figure out why nothing output when I make the visualization 

[Phil_Seamark · Accepted solution]

HI @frostys

Please try this tweak

Table = 
VAR CustomersPurchasedLast3Months = 
        SELECTCOLUMNS(
            FILTER(
                'Table2',
                EOMONTH('Table2'[Date],3)>TODAY()
                ),
            "Customer",[Controlling Customer Name])

RETURN EXCEPT(
            ALL('Table2'[Controlling Customer Name]),
            CustomersPurchasedLast3Months
            )   

[frostys]

@Phil_Seamark, But with this solution, it will just show the customers of the last 3 months ?

I was more thinking about a dax formula who output the customer who have not orders anything from the last 3 months 

[Phil_Seamark]

Hi @frostys

My formula only shows customers who have NOT make a purchase in the last three months.

First it detects those that have made a purchase, and then uses that list to excluded recent customers from the overall list.

[frostys]

Hi @Phil_Seamark,

Here is the output with the new formula 

 

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[frostys]

Hi Ashish_Mathur, 

I can not share this data.

Perhaps you know a dax function to detect the nonoccurence (of custumer) in a given time .