Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Tried many of the suggestions for This Period vs Last Period to calculate the customer churn, but cannot yet nail the solution down. The goal is to have the count and the list of customers that were transacting in the last X days, but did not in the last Y days. These 2 items possibly as variables. The context is there is a transaction table, where the daily "usage" (or sales) is reported. So typically a customer has usage on a daily basis, but we want to easily find those who stopped transacting in the short term. Any help appreciated, thanks!
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Share some data and show the expected result.
Very basic example:
Date | Customer | Sales |
2019-10-07 | CustomerY | 40 |
2019-11-15 | CustomerA | 23 |
2019-11-17 | CustomerB | 12 |
2019-12-08 | CustomerA | 78 |
Always using today (Dec 14 for the example) as the reference.
From this table, only Customer B had sales in the last 60 days, but no sales in the last 15 days.
The expected result is the list of customers matching these 2 criteria, to know who they are.
The 60 days and 15 days can be hardcoded in the measure for now, and eventually I would set them via a slicer.
Thanks!
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you very much, added those concepts to my report and it now works like a charm.
You are welcome.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |