cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
frostys Regular Visitor
Regular Visitor

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

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 :

 

1.PNG

 

Thank you for your help 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Phil_Seamark Super Contributor
Super Contributor

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

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
            )   

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

10 REPLIES 10
Phil_Seamark Super Contributor
Super Contributor

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

Hi @frostys

 

How can we tell which is a client?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

frostys Regular Visitor
Regular Visitor

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

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

1.PNG

 

Super User
Super User

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

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Phil_Seamark Super Contributor
Super Contributor

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

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
            )   

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

frostys Regular Visitor
Regular Visitor

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

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 .

frostys Regular Visitor
Regular Visitor

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

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 

 

Capture.PNG

Phil_Seamark Super Contributor
Super Contributor

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

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
            )   

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

frostys Regular Visitor
Regular Visitor

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

Hi @Phil_Seamark,

 

Here is the output with the new formula 

 

Capture.PNG 

 

 

 

frostys Regular Visitor
Regular Visitor

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

@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 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 54 members 974 guests
Please welcome our newest community members: