cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Need help with calculating slope(growth) with multiple groupings

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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

## Re: Need help with calculating slope(growth) with multiple groupings

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

Highlighted
Microsoft

## Re: Need help with calculating slope(growth) with multiple groupings

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors