Creating a column converting months to seasons

[Anonymous]

Hi there.

I have a table "Dates" that looks like below.

I would like to create a seasons column (in red) but unsure of the dax.

Nov, Dec, Jan = Winter

Feb, March, April = Spring

May, June, July = Summer

Aug, Sept, Oct - Autumn

StartMonth	Season
January	Winter
January	Winter
February	Spring
March	Spring
April	Spring
May	Summer

Would really appreciate some help with this.

[Greg_Deckler · Accepted solution]

@Anonymous Well, you could always do a SWITCH statement:

Season Column = 
  SWITCH([StartMonth],
    "November","Winter",
    "December","Winter",
    "January","Winter",
    "February","Spring",
    "March","Spring",
    "April","Spring",
    "May","Summer",
    "June","Summer",
    "July","Summer",
    "Autumn"
  )

[Anonymous]

Thank you both @Greg_Deckler and @themistoklis - both worked and I've learned something new!! Only new to powerbi so just learning as I go. 

[themistoklis · Accepted solution]

@Anonymous 

Another version of Switch can be this one:

New Column = SWITCH(
TRUE(),
'Table'StartMonth = "December" || 'Table'StartMonth = "January" || 'Table'StartMonth = "February", "Winter",
'Table'StartMonth = "March" || 'Table'StartMonth = "April" || 'Table'StartMonth = "May", "Spring",
'Table'StartMonth = "June" || 'Table'StartMonth = "JUly" || 'Table'StartMonth = "August", "Summer",
'Table'StartMonth = "September" || 'Table'StartMonth = "October" || 'Table'StartMonth = "November", "Autumn",
BLANK()
)

[Greg_Deckler · Accepted solution]

@Anonymous Well, you could always do a SWITCH statement:

Season Column = 
  SWITCH([StartMonth],
    "November","Winter",
    "December","Winter",
    "January","Winter",
    "February","Spring",
    "March","Spring",
    "April","Spring",
    "May","Summer",
    "June","Summer",
    "July","Summer",
    "Autumn"
  )