Forum Discussion
Building an ARR Snowball in PowerBI
I am trying to build out an ARR Snowball where I would have the following table:
| Feb 2023 | Mar 2023 | April 2023 | May 2023 | |
| Beginning ARR (Prior Month Revenue) | 1,000,000 | 1,040,000 | 1,200,000 | 1,250,000 |
| New Customer | 50,000 | 170,000 | 100,000 | 10,000 |
| Lost Customer | -10,000 | -10,000 | -50,000 | -10,000 |
| Ending ARR | 1,040,000 | 1,200,000 | 1,250,000 | 1,250,000 |
My data set is revenue by month, but struggling to get the data in a format to show the descriptions in the first column. I know I can create a calculation to calculate change month-over-month to capture New and Lost customer, but can't find a forum that shows how to display the table in this format.
5 Replies
- Ashish_Mathur
Super User
Hi,
Share data in a format that can be pasted in an MS Excel file.
Is this what you are looking for?
Division Type Month Revenue Product A Subscription revenue Apr 2023 1000 Product B Subscription revenue Apr 2023 500 Product A Subscription revenue May 2023 1200 Product C Subscription revenue May 2023 750 Product B Subscription revenue May 2023 800 - Ashish_Mathur
Hi,
Based on this 5 row raw data table that you have shared, show the expected result. What will be opening ARR of April be?
