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"))

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.