Forum Discussion
powerbiexpert22
Impactful Individual
Impactful Individuallost customers
the lost customers should show 0 it is showing 4 as below highlighted, i have created 3 measures to calculate lost customers. lost customers are those customers who have not done any purcase last 2 ...
Hi powerbiexpert22
The output seems to be working as per the logic[No purchase in last 2 month], as of 12-01-2024 c1 has made a purchase while other 4 has not.
Can you explain the requirement a bit more elaborate?
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
LinkedIn
NaveenGandhi
Memorable Member
Memorable MemberHi powerbiexpert22
Check the below solution, I have created a calculated column.
Let me know if this works.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
LinkedIn
powerbiexpert22Impactful Individual
Impactful Individual- NaveenGandhi
Look for lost column on sales table, you can neglect the summarize table
Regards,
Ng