cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

 Capture.PNG

1 REPLY 1
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!