Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In the 2.104.941.0 64-bit (april 2022) version of Power Query, the Format Code "M" returns first day of month and month name;
Date.ToText(#date(2010, 12, 31), "M", "en-US")
returns
December 1
Which is not the expected value 12. A workaround is of course simple; using
Number.ToText(Date.Month([Date]))
However, it's still a bug.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Anonymous,
Please try the recent version of Power BI Desktop.
Latest version of PBI Desktop: Downloads | Microsoft Power BI
Older version of PBI Desktop: Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Docs
As you can see, if test in 2.105.1143.0 64-bit (May 2022), it works well.
Best Regards,
Community Support Team _ Caiyun