Need help with calculating slope(growth) with multiple groupings

[justin_leow]

Hi All, thank you so much for answering to my question as I am very new to Power BI / DAX language. I am in need to create a table that can show me sales growth from multiple groupings or BUs, with multiple transactions. 

Example data:

Sale ID,Month, BU, Sales

S01, Dec-2016, Food, $3
S02, Jan-2017, Drinks, $5
S03, Jan-2017, Food, $1
S04, Feb -2017, Books, $7
S05, Mar-2017, Food, $2
S06, Mar-2017, Books, $6
S07, Apr-2017, Drinks, $3
S08, Dec-2016, Food, $2
S09, Jan-2017, Books, $2
S10, Dec-2016, Books, $5
S11, Jan-2017, Books, $1
S12, Mar-2017, Food, $8
S13, Apr-2017, Drinks, $9
S14, Apr-2017, Food, $3

S15, Mar-2017, Drinks, $3

And I would like output to be able to get the slope/growth of sales over the time period. The data is just for illustration. 🙂

Can someone help me? ><

	1	2	3	4	5
Row Labels	Dec-16	Jan-17	Feb-17	Mar-17	Apr-17	Grand Total	SLOPE (5mth Growth)
Drinks		5		3	12	20	186%
Food	5	1		10	3	19	50%
Books	5	3	7	6		21	70%
Grand Total	10	9	7	19	15	60

[v-huizhn-msft · Accepted solution]

Hi @justin_leow,

I reproduce your scenario and get expected result.

Create a measure using the formula: 

Sum-Sale = SUM(TTest[Sales])

 Then create a matrix, select the month as column level, the BU as row level, the measure as value, please see the screenshot below.



After research, I still don't know how to calculate the SLOPE result? Please list an example for further analysis.

Best Regards,
Angelia