Forum Discussion
Calculate retention by month
Hi all, I am looking to calculate the retention rate of our members. I was wondering if its possible to do it in one and show the % in a Card? Each member has a unique ID and a membership status...
Hi MrAtkinson ,
Are you saying there is no date format in your data, without a date it is impossible to determine if the data is for the current month, is there any other column instead of a date column to determine the current month or is there some calculation logic.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.