How to make a separate month and year column from a date column?

[Niels_T]

Hello,

I have a column as followed:

From this collumn I would like to make 2 new column's a year column (2018, 2019, 2020) and a month column (January, February, etc.).

Is there any way how to do this?

- N

[ryan_mayu · Accepted solution]

@Niels_T 

year column = year(updated_at)

month column =format(updated_at, "mmmm")

[renatob]

I could use the dax command month and the year 

then example for month and year