Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
5 years ago
Solved

Month Custom Column

How can I add a month name custom column within power Query?  I have a Complete date  column already loaded, but want a custom column in format "mmm-yy"
  • edhans's avatar
    5 years ago

    use this formula:

    Text.Start(Date.MonthName([Date]), 3) & "-" & Text.End(Text.From(Date.Year([Date])), 2)

    It returns this. You just need to set the column type to Text when done jcastr02 

     

  • Jimmy801's avatar
    5 years ago

    Hello jcastr02 

     

    you can use the formula Date.ToText like this

    Date.ToText([Date],"MMM-yy")

    Here the complete example

    let
        Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTVMzDUMzJQitWBcwyVYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t]),
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}, "de-DE"),
        #"Added Custom" = Table.AddColumn(#"Changed Type", "MMM-yy", each Date.ToText([Date],"MMM-yy"))
    in
        #"Added Custom"

    Copy paste this code to the advanced editor in a new blank query to see how the solution works.

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy