Forum Discussion

LizardBoi's avatar
LizardBoi
Regular Visitor
5 years ago
Solved

Assign text depending on Date

Hi All Im looking for some help in creating a column in my date table that will allocate the season the date is in. I need the information to be created regardless of year - but to include the year...
Need Help
Show and Tell
Tips and Tricks
  • selimovd's avatar
    selimovd
    5 years ago

    Hey LizardBoi ,

     

    yes, you can do that with a calculated column. Try the following approach:

    Season = 
VAR vMonth = MONTH(myDateTable[Date])
VAR vYear = YEAR(myDateTable[Date])
RETURN
SWITCH(
    TRUE(),
    vMonth >= 5 && vMonth <= 10, "S" & RIGHT(vYear, 2),
    vMonth <= 4, "W" & RIGHT(vYear-1, 2) &" /" & RIGHT(vYear, 2),
    vMonth >= 11, "W" & RIGHT(vYear, 2)   & "/" & RIGHT(vYear+1, 2)
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey LizardBoi ,

 

yes, you can do that with a calculated column. Try the following approach:

Season = 
VAR vMonth = MONTH(myDateTable[Date])
VAR vYear = YEAR(myDateTable[Date])
RETURN
SWITCH(
    TRUE(),
    vMonth >= 5 && vMonth <= 10, "S" & RIGHT(vYear, 2),
    vMonth <= 4, "W" & RIGHT(vYear-1, 2) &" /" & RIGHT(vYear, 2),
    vMonth >= 11, "W" & RIGHT(vYear, 2)   & "/" & RIGHT(vYear+1, 2)
)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • LizardBoi's avatar
    LizardBoi
    Regular Visitor
    5 years ago

    Excellent - Thank you this worked a treat