MM-YY Format in M Date Code?

Power Query
2

Hi @gkavesh

Add a column with M code and apply the following formula

Date.ToText([Date],“MM-yy”)

Then use that column in report for the axis.
Important to use lower case “y”.

Cheers
Pete

1 Like