If my distinct Customers in July 2015 are 1,648, only 822 are retained out of those 1,648 after 1M(1month) and so on and so forth.
Similarly for subsequent months distinct customers are calculated and further calulations of retention are done based on the Initial Data.
Can someone please help me with the DAX functions and the method to proceed further.
Actually you have clarified your table structure very well. In addtion would you please tell me what's the expected value? Are you trying to calculate come percentage like increase rate or decrease rate? To be general, you may refer to quick measure about how to create measures using DAX function in power bi to achieve what you want.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.