Date and Month Format

Hi Dev-13 ,

Try this as a new custom column:

Text.Combine(
    {
        Text.From(Date.Year([date])),
        "M",
        Text.PadStart(Text.From(Date.Month([date])), "0", 2)
    }
)

Pete

Hi Dev-13,

The easiest way to achieve this is by making use of the Date.ToText function. 

 Date.ToText( [Date], [Format = "yyyy'M'MM"] )

 The formatting strings allow you to turn a date (in the [Date] column) into your desired custom output. For the different possible output strings, take a look at : https://powerquery.how/date-totext/

There's an extensive list and image with example format strings. 

Regards,

Rick

--------------------------------------------------

@ me in replies or I'll lose your thread

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.