//sk - Month on Month Growth calculation - Volume and Value

[sansk23]

Hi. i dont have the date wise sales data.

instead have only the territory wise / product wise total monthly historic sales data. 

How can i calculate the Month on Month growth - for each territory / product.?

Br,

//sansk

[Rohini]

Can you share the sample data you have?

[sansk23]

Hi Rohini. Pls. find below the sample data. Trust this takes care of the requirement.

First step - Could look at the Month on month growth of a particular territory - all products put together. 

Next step - Could then look at for a given territory how has a particular product seen growth / de-growth.

Year	Month	Territory	Product	Sale Qty	Sale Value
2018	January	A	X	100	100000
2018	February	B	Y	200	150000
2018	March	C	Z	300	200000
2018	April	D	X	400	250000
2018	May	E	Y	500	300000
2018	June	F	Z	600	350000
2018	July	G	X	700	400000
2018	August	H	Y	800	450000
2019	March	A	X	900	500000
2019	April	B	Y	1000	550000
2019	May	C	Z	1100	600000
2019	June	D	X	1200	650000
2019	July	E	Y	1300	700000
2019	August	F	Z	1400	750000
2019	September	G	X	1500	800000
2019	October	H	Y	1600	850000
2019	November	I	X	1700	900000

Br.

//sansk

[v-chuncz-msft · Accepted solution]

@sansk23 

Try using CALCULATE Function to change the context.

• https://community.powerbi.com/t5/Desktop/Year-on-year-for-previous-reporting-period/m-p/326661#M1457...
• https://www.sqlbi.com/articles/filter-arguments-in-calculate/

[Rohini]

I have been trying to use same however the following formula for Previous Month Sales is being tried =

Calculate([Sale Value],Parallelperiod(Sheet1[Month_Date],-1 ,MONTH))

There seems to be an issue with the Parallelperiod function. It ends up with the error - 'Sale Value' cannot be found or may not be used in this expression.

The Previous month sales value is required to be able to calculate the month-on-month growth