How to calculate Year to date (YTD) Growth rate?

Question

Hi, I have build a forecast model and need to show the Year-to-Date growth rate. Is there a systematic way of doing it? Regards, Atyagi

PrevContributor · Accepted Answer

Jill King: The following formula would work to do annual YTD cumulations where VALUE2 is the item you want to cumulate and you are using a monthly timescale:

CUMULATE('VALUE2') - OFFSET(CUMULATE('VALUE2'), -MONTH(START()), 0)

I found this in another thread. its helpful and solves my problem.