Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have 3 tables
1. A customer table that contains details of all customers
2. A Subscription table that contains ONLY customer on our subscription plan.
3. A transaction table that contains all customer transactions.
The customer ID links all three tables.
The subscription is renewed every month through an auto debit on the customer's account and this transaction is registered both on the transaction table and the subscription table.
The team would like to track each new subscriber to the bundle daily. We have multiple renewals daily but we to count new subscribers to the subscription ONLY.
We may have a new customer that is transacting but isn't subscribed to the bundle yet. What i want to do is count each first time subscriber to the bundle irrespective of when you became a customer. So each time a subscription transaction hits the transaction table it checks to see if that number is already subscribed, If yes; It doesnt count, If no it counts.
Tired DISTINCTCOUNT but dosnt count correctly.
Hi @Anonymous ,
Same thread opened in
https://community.powerbi.com/t5/Desktop/Counting-Daily-New-Subscribers/m-p/1172321#M528676
Regards,
Harsh Nathani
All you need is to check the transaction count by customer. If that count is 1 then the customer is new, no?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
42 | |
39 | |
33 | |
19 | |
18 |