Convert date from 01.01.2024 to Month year (Jan 24)

[WhaleWatcher222]

Hi Experts

Need help in convert a date in the format 01.01.2024 too month year format (Jan 24) in Power Query. do not want to do this as a calculated column.

I have tried and its not working (gives me Jan YY)

Table.AddColumn(#"Renamed Columns", "Month Year", each Date.ToText([reading_date],"MMM YY"))

[jgeddes · Accepted solution]

Try changing the Date.ToText function like this...
Date.ToText([reading_date], [Format="MMM yy"])

https://learn.microsoft.com/en-us/powerquery-m/date-totext