Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Season column in date table

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 Hemisph...
Need Help
Show and Tell
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    Hi Anonymous 

    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.

     

jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

Hi Anonymous 

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.