Season column in date table

[SophRow]

Hi,

I've created a Date table using DAX that has columns for Date, Year, Month and Day. 

I want to create a new column called "Winter" that will have values as either:

- "Southern Hemisphere" for May - September

- "Nothern Hemisphere" for November - March

- "Not Winter" for April and October

Can someplease please help with the DAX?

Best,

Soph

[jdbuchanan71 · Accepted solution]

Hi @SophRow 

Give this a try.

Winter = SWITCH(
    TRUE(),
    MONTH(Dates[Date]) IN {5,6,7,8,9}, "Southern Hemisphere",
    MONTH(Dates[Date]) IN {11,12,1,2,3}, "Northern Hemisphere",
    "Not Winter"
)

You would add this as a calculated column to your Dates table.