topic Calculate the growth in unique objects by month in DAX Commands and Tips

Calculate the growth in unique objects by month

Anonymous — Mon, 09 Nov 2020 09:41:04 GMT

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?

Re: Calculate the growth in unique objects by month

amitchandak — Mon, 09 Nov 2020 09:53:54 GMT

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