extracting the month from a date field

[Anonymous]

Hi

I have a field that contains dates and want to just take out the month so I can plot a series of data points against that single month value instead of a range of date. Is there a function/measure/dax that will look at the date and return just the month value from it?

THanks!

Paul

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Try:

MONTH([date])

This will give you the month NUMBER (e.g. Jan = 1, Feb = 2 etc.).

If you want this to be more user-friendly, you could add a SWITCH(), something like this:

MyMonth =
SWITCH(
    TRUE(),
    MONTH([date]) = 1, "Jan",
    MONTH([date]) = 2, "Feb"... etc.

Good luck

[az38]

@Anonymous @BA_Pete 

🙂

or you can get month name by 

Column =[Date].[Month]

or

Column = FORMAT([Date], "mmm")

or

Column = FORMAT([Date], "mmmm")

[BA_Pete]

Ah, yes. Do what @az38 said. Way tidier.

@Anonymous