Cumulative Sales by Month (MMM)| Excel 365 Dynamic Array|Power Query M| Postgre SQL

One Problem – Three Solutions: Excel Dynamic Array, Power Query M & PostgreSQL

How do you calculate cumulative sales based on the month name (MMM format)?

In this video, I demonstrate how to calculate cumulative sales based on the month name (short format – MMM) using three powerful tools:

• Excel 365 Dynamic Array formulas (Groupby, Hstack, Text, Drop)
• Power Query M (Date.ToText, Date.From, Groupby)
• PostgreSQL (Extract, To_Char, Group by, Order by)

You will learn how to extract the month name from a date, group the data by month, and correctly sort the results from January to December using the month number.

This practical example will help you improve your data analysis skills in Excel and SQL.

If you have another approach to solve this problem, feel free to share your solution in the comments.

Download Practice File:
https://1drv.ms/x/c/F66A2644F1B4537C/IQBP8X7L4Hu-Sra1PmyKXeewAW0QWIieqt5wlmLLWkzLGWY?e=dsjZzZ

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

Please follow our Social Media:
https://www.linkedin.com/in/shahalam-analytics-excelbi/
https://www.facebook.com/ShahAlamDataTrainingAnalytics/
https://www.shahalamanalytics.com/

@ShahAlamAnalytics | Md Shah Alam | Microsoft Certified Trainer | Excel | Power BI

Видео Cumulative Sales by Month (MMM)| Excel 365 Dynamic Array|Power Query M| Postgre SQL канала ShahAlam: Data Training & Analytics