Date.ToText Power Querry issue

[kivanct]

Hi,

I wanted to change date format by using power querry. To do that I ve used "Date.ToText" function. In custom column as you can see  I am getting "00" instead of month numbers like "02" , "03". 

What is to reason for that ? Which function i should use ? 

Regards

[Niniko]

Dear all, my result shows error, do you know why? i'm sure the column used is datetime format.

[Migasuke · Accepted solution]

Hi @kivanct ,

months in the function must be MM because M language is case sensitive. Formula should be then like this:
Date.ToText([Dates],"yyyy-MM")

Overview of all format options can be seen here:
https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

[kivanct]

Hi @Migasuke 

Thanks a lot.