Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.