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. 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
Solved! Go to Solution.
Try using CALCULATE Function to change the context.
Can you share the sample data you have?
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
Try using CALCULATE Function to change the context.
I have been trying to use same however the following formula for Previous Month Sales is being tried =
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |