Forum Discussion
Help! Month over Year calculation/comparison
I found this response on the Microsoft Community that will ultimately get me where I need to go: https://community.fabric.microsoft.com/t5/Desktop/spread-revenue-over-future-months/td-p/607050
The response from v-jiascu-msft was the answer I needed!
Figured I'd give a generic example that may help:
Customer X's initial contract was January 1, 2022 through December 31, 2022. Their TCV was $12,000, so their MRR is $1,000 in 2022. When they renewed their contract in 2023, we doubled their contract (super unlikely but makes for easy math). So, for January 1, 2023 through December 31, 2023, their TCV is now $24,000 so their MRR is $2,000 in 2023.
If I want to look at Customer X's growth and compare specifically October 2023 against October 2022, I should be able to tell we upsold them and the difference is $1,000 MRR.