Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query Date Year Column from Date

Hi Expert

 

How would you convert the following as a column (01/01/2012) in Power Query to Jan-12. My column with the date is called Year

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Please correct me if I wrongly understand your question.

     

    Please check the below picture if that is what you are looking for.

     

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Anonymous 

    = Table.AddColumn(Source, "Custom", each Date.ToText(Date.From([Year], "Fr"), "MMM-yy"))

2 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    5 years ago

    Anonymous 

    = Table.AddColumn(Source, "Custom", each Date.ToText(Date.From([Year], "Fr"), "MMM-yy"))

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    Please correct me if I wrongly understand your question.

     

    Please check the below picture if that is what you are looking for.

     

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.