Forum Discussion
Calculating distinct client growth rate
Hi! I have to show the growth rate month over month of distinct clients between two databases. The data base A has dates, but data base B doesn't, so they can be added at the beggining. ...
Ashish_Mathur
Super User
Super UserHi,
Create a Calendar Table with calculated columns for Year, Month name and Month number. Sort the Month name by the Month number. In the matrix visual, drag Year and Month name from the Calendar Table. Write these measures
Customer count = distinctcount(Data[Client_id])
Customer count in previous month = calculate([Customer count],previousmonth(Calendar[Date]))
Growth in customer count in previous month (%) = divide(([Customer count]-[Customer count in previous month]),[Customer count in previous month])
Hope this helps.