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
powerbiexpert22Impactful Individual
Impactful IndividualHi AnkitaaMishra , NaveenGandhi
Lost customers are those customers who placed orders before last 2 months from the specified date however they did not place any order within last two months from the specified date , below is the explanation based on the data
| Date | Lost Customer Count | Reason |
| 12-01-2024 | 0 | There are no customers who placed any order before 12-Nov-2023 |
| 14-02-2024 | 0 | There are no customers who placed any order before 14-Dec-2023 |
| 15-02-2024 | 0 | There are no customers who placed any order before 15-Dec -2023 |
| 16-03-2024 | 0 | There is 1 customer who placed orders before 16-Jan-2024 i.e C1 on 12th Jan 2024 but he placed another order on 14th Feb 2024 so he is not the lost customer |
| 26-04-2024 | 2 | There are 2 customers who placed orders before 26-Feb-2024 i.e. C1,C2 and they have not placed any order between 26-Feb-2024 and 26-Apr-2024 so these two are lost customers |
| 28-04-2024 | 2 | There are 2 customers who placed orders before 28-Feb-2024 i.e. C1,C2 and they have not placed any order between 28-Feb-2024 and 28-Apr-2024 so these two are lost customers |
| 31-05-2024 | 3 | There are 3 customers who placed orders before 31-Mar-2024 i.e. C1,C2,C3 and they have not placed any order between 31-Mar-2024 and 31-May-2024 so these three are lost customers |