Showing results for 
Search instead for 
Did you mean: 
marmar New Member
New Member

Change Date to Month, Year

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.


Super User
Super User

Re: Change Date to Month, Year

In DAX that would be:


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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!