Power Query Date Year Column from Date

[Anonymous]

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

[Jihwan_Kim · Accepted solution]

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 · Accepted solution]

@Anonymous 

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

[Jihwan_Kim · Accepted solution]

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.