cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## Seasonality 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

1 ACCEPTED SOLUTION
Super User

@Syndicate_Admin solution is attached, tweak it as you see fit.

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!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

5 REPLIES 5
Super User

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!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

@Syndicate_Admin solution is attached, tweak it as you see fit.

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!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

It works perfectly! Thank you very much for the help!!!!!

Super User

@Syndicate_Admin what happens if you have 3 years of data, then sum month all 3 years and divide by the total?

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!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.