Date from Year-Month Text in Power Query M

Converts a YYYY-MM text value into the first day of that month as a real Date.

Date & TimeBeginneryear monthdateconverttext

Power Query M code

let
    Source = YourTable,
    AddedDate = Table.AddColumn(Source, "MonthDate", each #date(Number.From(Text.Start([YearMonth], 4)), Number.From(Text.End([YearMonth], 2)), 1), type date)
in
    AddedDate

Generate a date table in Power Query M

Notes

Assumes YearMonth is formatted like "2026-03"; adjust the Text.Start/End offsets for other formats.

Requirements

A text column formatted as YYYY-MM.

How to use this snippet

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).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Date from Year-Month Text.