cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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? ><

 

 

 12345  
Row LabelsDec-16Jan-17Feb-17Mar-17Apr-17Grand TotalSLOPE (5mth Growth)
 Drinks 5 31220186%
 Food51 1031950%
 Books5376 2170%
Grand Total1097191560

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
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.

1.PNG

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

Best Regards,
Angelia

View solution in original post

1 REPLY 1
Highlighted
Microsoft
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.

1.PNG

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

Best Regards,
Angelia

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors