Solved: Re: Power Query Date Year Column from Date

Anonymous · ‎04-02-2021

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 · ‎04-02-2021

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

View solution in original post

CNENFRNL · ‎04-02-2021

@Anonymous

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

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!