Showing results for 
Search instead for 
Did you mean: 
Phil_Seamark Super Contributor
Super Contributor

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

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.

To learn more about DAX visit :

Proud to be a Datanaut!

Helpful resources

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

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: 310 members 2,802 guests
Please welcome our newest community members: