Forum Discussion
VALUES() returning blank - Customer Churn
Hi batmit25 ,
I thought of a possibility that could cause me to run fine but you can't show it. I'm using the latest version of Desktop, but when I open the pbix file you provided, it says that you are using an older version of Desktop, I suspect it's because of the version, you can try to use the newer version of Desktop and try again.Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I apologize, that's my first community post, I'll try to be more precise as I go. My question was as how to classify customers of a store as lost customers(The logic being if a customer made a purchase last month and dint make a purchase this month, Then they'd be a lost customer) with DAX.
| Customer ID | Sales Last Month | Sales This Month |
| A-123 | 23 | 25 |
| B-123 | 12 | |
| C-123 | 45 | |
| D-123 | 35 | |
| E-123 | 23 |
Sales This Month = CALCUALTE([Sales],DATESMTD[Date Table])
Sales Last Month = CALCULATE([Sales],DATESMTD(DATEADD([Date Table],-1,MONTH))
The following is the result I need,
| Customer ID | Sales Last Month | Sales This Month | Lost Customer |
| A-123 | 23 | 25 | |
| B-123 | 12 | 1 | |
| C-123 | 45 | ||
| D-123 | 35 | 1 | |
| E-123 | 23 |
I hope this was a bit more clear and concise, if not let me know how I could make the question more clear 😅.
I apologize again for the vague question; I tried to add as much context as I could as I'm a Novice at Power Bi. Thank you for the help!