March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I've been looking around and have found lots of examples of calculating the number of unique values occuring per year or per month, for example for calculating the number of unique website visitors per month. But what I need to do it calculate the number of truly new unique values each month, so it's a calculation of growth not occurance. For example:
MonthYear | Company Name |
Feb-20 | Company A |
Feb-20 | Company B |
Mar-20 | Company A |
Mar-20 | Company C |
Would be displayed as:
MonthYear | Growth |
Feb-20 | 2 |
Mar-20 | 1 |
Any help?
@Anonymous , for this, refer to my customer retention blog. In this case, your context is month and customer.
The second blog uses a bigger last duration. You are looking for new customer as per the blog
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
31 | |
19 | |
15 | |
14 | |
10 |
User | Count |
---|---|
62 | |
25 | |
24 | |
22 | |
16 |