Seasonality by month

[Syndicate_Admin]

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

[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!

[Ashish_Mathur]

Share the exact structure of your raw data table(s). 

[parry2k · Accepted solution]

@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_Admin]

It 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!