Month-Year Sort Column (e.g., 2026-03) in Power Query M

Notes

Use MonthYearSort as the 'Sort by column' for a MonthName or MonthYear label column in the model.

Requirements

• A table with a date column.

How to use this snippet

1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Week Start and Week End DatesAdds columns for the Monday (week start) and Sunday (week end) of the week each date falls in.
• Convert Excel Serial Number to DateConverts an Excel date serial number (like 45000) stored as a number into a real Date value.
• Days Between Two DatesCalculates the number of whole days between two date columns.
• Date from Year-Month TextConverts a YYYY-MM text value into the first day of that month as a real Date.
• Relative Date Labels (Today, Yesterday, Last 7 Days)Adds a text column that labels each date relative to today, such as Today, Yesterday or Last 7 Days.
• Convert Text to Date (Multiple Formats)Tries several known date formats in order and returns the first one that parses successfully.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Month-Year Sort Column (e.g., 2026-03).