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 Hemisphere" for May - September

- "Nothern Hemisphere" for November - March

- "Not Winter" for April and October

 

Can someplease please help with the DAX?

 

Best,

Soph

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.

     

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper 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.