Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Creating a column converting months to seasons

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
JanuaryWinter
JanuaryWinter
FebruarySpring
MarchSpring
AprilSpring
May Summer

 

Would really appreciate some help with this.

2 ACCEPTED SOLUTIONS
Greg_Deckler
Community Champion
Community Champion

@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"
  )


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

themistoklis
Community Champion
Community Champion

@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()
)

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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
Community Champion
Community Champion

@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
Community Champion
Community Champion

@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"
  )


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors