Month Name in Text from Date Column

[Mischief63]

My apologies for stating what is no doubt the obvious to most of you, but didn't realize how easy it was to get generate a column with the month name in text from the date column

Highlight Date Column
Go to Add Column
Click on drop date down and choose month

 

[MarcelBeug]

Correction: you should choose Name of Month, not month...

You can even adjust the generated code to get the month name in another language, e.g. French:

= Table.AddColumn(#"Renamed Columns", "Month Name", each Date.MonthName([Date], "fr-FR"), type text)

 

[Mischief63]

Hi. Another mystery - at home I get that "Name of Month" in the Drop Down. But at work the "Add Column" Tab Date box on has these choices under Month:
Month
Start of Month
End of Month
Days in Month

 

[MarcelBeug]

The option is available on the Transform tab, the Add Column tab and in the dropdown if your right-click a column header.

Note that Power Query has many dropdowns, so "the dropdown" is not very clear.

I my view, the mystery is not that it is available in multiple places, but that it would not be available where it should be available.

Possibly you are working with different versions at home and at work (in Excel: check File - Account; in Power BI Desktop: File - Help - About).

 

[Mischief63]

Got it about the drop-down references.

As far as versions, that's what I'm starting to wonder. The version on our desktops is Microsoft Office Professional Plus 2016. Are you saying that they updates are different for the Office 365 Product?

 

[MarcelBeug]

Yes, there are different update channels and these are the current versions.

If I look in Excel - File - Account - I'm on version 1704, Build 8067.2032 (a bit strange as this is not yet documented?).

It also depends if you have an Office 365 subscription or not.