extract year and month from date

[Anonymous]

i have a date column now i want to extract month and year from date column .. how i do this 

i want to do this in table .. 

this automated date hierachy is created but not visible in table 

[danextian]

Hi @Anonymous ,

You  can  use FORMAT function in DAX which works similarly as text in Excel.

So  for month name, you can  create a calculated column with

Month Name = 
FORMAT ( Table'[Date], "mmmm" )

For year

YEAR = 
FORMAT ( Table'[Date], "yyyy" )

 or

Year = 
YEAR('Table'[Date])

[johncolley · Accepted solution]

Hi @Anonymous , on the table with your date field you can create the following:

Year = YEAR(datefield)
Month = MONTH(datefield) this returns a number from 1-12
MonthName = FORMAT(datefield, "MMM")

If this answer solves your problem please mark it as a solution!