Change Date to Month, Year

[marmar]

Hello, I want to create a column where it only has Month, Year instead of my current DATE (image below) . I tried spliting and even creating a new column and it is not working. I want to keep my current Date I have, however I want to create a new column that only has Month, Year.

 

[Anonymous]

Hello,

I know this is quite an old post but for any that are looking for this answer at the time of this reply, how I was able to achieve this was by adding a new Custom Column for the result in the format "mm-yyyy":

New_Column_Name

= DateTime.ToText([field_name], "mm") & "-" & DateTime.ToText([field_name], "yyyy")

The "-" can be replaced with any symbol you want to divide the month and year.

In my case I wanted the result to be the full month name and abbreviated year (ex: September '19). How I achieved this:

New_Column_Name

= Date.MonthName([field_name], "optional_culture") & DateTime.ToText([field_name], "yyyy")

Please keep in mind that because this new column is Text, they will be sorted alphebetically and not chronologically. To sort the new column chronologically: When in Report View, select the newly created field in your Fields Pane, then select Sort by Column button in the Modeling ribbon and choose the initial [field_name] used to create this new column (in your case Date Given).

Hope this helps!

[Greg_Deckler]

In DAX that would be:

MonthYear = FORMAT([Date Given],"mm, yyyy")