Forum Discussion
Meagan
Most Valuable Professional
10 years agoLost Customers - Issues with DAX Calculation
I'm having an issue with a DAX calc for lost customers and I'm hoping someone can spot where we went wrong. I have followed the pattern described in http://www.daxpatterns.com/new-and-returning-custo...
- 10 years ago
Good point - you have to remove some filter from the CustomerLostDate column expression.
Try this one replacing the ADDCOLUMNS in original formula:
ADDCOLUMNS ( CALCULATETABLE ( VALUES ( Customer[CustomerCode] ), Sales ), "CustomerLostDate", CALCULATE ( MAX ( Sales[Invoice Date] ), ALLEXCEPT ( Customer, Customer[CustomerCode] ) ) + [Lost Days Limit] )
zkazimov
Helper I
8 years ago
This is great! Summarize Function did the job. Thanks a lot for time spent on this Appreciated.
Ashish_Mathur
Super User
8 years ago