How To Calculate Annual Retention Rate Month-Over-Month

Hi Daniel,

Here's my updated pbix file.

This is what the table looks like now:

The key changes I made were:

• Creating a relationship between the calendar table and the All Data table
• Replacing the month field in your table visual with the month field from the Calendar table
• Slight tweaks to your measure

Since you said you are fairly new, I love recommending SQLBI's free courses whenever I can. They'll help set you up with a good foundation! 😄

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI issue? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.