Creating an Index off yearly % changes

[ajamess]

I have figured out a way to create a weighted average based on sales growth by year to get a table like this

2012	2013	2014	2015	2016
2%	-5%	3%	6%	1%

<tbody>
</tbody>

Is there a way I could make this into an index starting at 100 with the % changing each month to graph, for example I'd like a graph with these values:

2011	2012	2013	2014	2015	2016
100	102	96.9	99.8	105.8	106.9

<tbody>
</tbody>

Any suggestions?

 

[DRSteele]

Unless I'm missing something, this seems like what you want.

Copy B5 across. Create a chart out of A4 to F5.

	A	B	C	D	E	F
1		2012	2013	2014	2015	2016
2		2%	-5%	3%	6%	1%
3
4	2011	2012	2013	2014	2015	2016
5	100.0000	102.0000	96.9000	99.8070	105.7954	106.8534

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B5 =A5*(1+B2) <tbody> </tbody>

<tbody>
</tbody>

 

[ajamess]

Unless I'm missing something, this seems like what you want.

Copy B5 across. Create a chart out of A4 to F5.

	A	B	C	D	E	F
1		2012	2013	2014	2015	2016
2		2%	-5%	3%	6%	1%
3
4	2011	2012	2013	2014	2015	2016
5	100.0000	102.0000	96.9000	99.8070	105.7954	106.8534

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B5 =A5*(1+B2) <tbody> </tbody>

<tbody>
</tbody>

This is exactly what I am looking for. And I have already done this in excel, however I have a dataset much too large for excel, so I am hoping to be able to find out how to do this in PowerBI (This is in PowerBI category of the forum, not excel)

 

[DRSteele]

Oh heavens! I didn't notice that it was BI. Sorry, I haven't got BI so I can't help.