Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How To Calculate Annual Retention Rate Month-Over-Month

Hello All,   I've hit a bit of a roadblock with this one, and I'm hoping the community can help me resolve it. I'm still a fairly new PBI user, so it's likely I'm missing something obvious.   The...
Need Help
Tips and Tricks
  • Wilson_'s avatar
    Wilson_
    2 years ago

    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.