Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
|
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |