Forum Discussion
AdministratorSeasonality by month
Good afternoon everyone! I'm needing to calculate the seasonality per month of sales based on data from two previous years.
I give as an example this sales data per month:
| one-20 | 10 |
| feb-20 | 15 |
| mar-20 | 25 |
| Apr-20 | 30 |
| may-20 | 10 |
| Jun-20 | 15 |
| jul-20 | 10 |
| ago-20 | 8 |
| sep-20 | 7 |
| oct-20 | 12 |
| nov-20 | 15 |
| Dec-20 | 21 |
| Total | 178 |
| one-21 | 12 |
| feb-21 | 18 |
| mar-21 | 30 |
| Apr-21 | 36 |
| may-21 | 12 |
| Jun-21 | 18 |
| jul-21 | 12 |
| ago-21 | 9,6 |
| sep-21 | 8,4 |
| oct-21 | 15 |
| nov-21 | 18 |
| Dec-21 | 23 |
| Total | 212 |
The Formula in Excel for calculating january seasonality would be = ( (10+12) / (178+212) ) * 100 = 5.64%
The result of seasonality per month would be:
| one | 5,64% |
| feb | 8,46% |
| mar | 14,10% |
| Apr | 16,92% |
| may | 5,64% |
| Jun | 8,46% |
| jul | 5,64% |
| ago | 4,51% |
| sep | 3,95% |
| oct | 6,92% |
| nov | 8,46% |
| Dec | 11,28% |
Someone could help me with the Power Bi measure needed to reach these results???
Thank you very much for the help!
Fred
Syndicate_Admin solution is attached, tweak it as you see fit.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
5 Replies
- parry2k
Super User
Syndicate_Admin solution is attached, tweak it as you see fit.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
Syndicate_AdminIt works perfectly! Thank you very much for the help!!!!!
- parry2k
Syndicate_Admin what happens if you have 3 years of data, then sum month all 3 years and divide by the total?
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
- Ashish_Mathur
Share the exact structure of your raw data table(s).
- parry2k
Syndicate_Admin Glad to hear. Please "Accept as solution" so that others can take advantage of it.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
