Forum Discussion

WJ876400's avatar
WJ876400
Helper IV
6 years ago
Solved

If Statement With Dates

Hi

 

I have the below dates and want to group them togerther in Terms. So if a date is between September and December it is Term 1, between January-April is Term 2, May-August is Term 3. I am looking at the month in the date. What is the best way to do this?

 

thanks

 

01/01/2020Term 2
01/02/2020Term 2
01/03/2020Term 2
01/04/2020Term 2
01/05/2020Term 3
01/06/2020Term 3
01/07/2020Term 3
01/08/2020Term 3
01/09/2020Term 1
01/10/2020Term 1
01/11/2020Term 1
01/12/2020Term 1

 

thanks

Need Help
  • Gordonlilj's avatar
    Gordonlilj
    6 years ago

    Hi,

     

    You could achieve this by using MONTH in a SWITCH function like below

     

    Term = 
SWITCH(TRUE(),
MONTH('Table'[Date]) >=1 && MONTH('Table'[Date]) <=4,"Term 2",
MONTH('Table'[Date]) >=5 && MONTH('Table'[Date]) <=8,"Term 3",
MONTH('Table'[Date]) >=9 && MONTH('Table'[Date]) <=12,"Term 1")

     

     

1 Reply

  • Gordonlilj's avatar
    Gordonlilj
    Solution Sage
    6 years ago

    Hi,

     

    You could achieve this by using MONTH in a SWITCH function like below

     

    Term = 
SWITCH(TRUE(),
MONTH('Table'[Date]) >=1 && MONTH('Table'[Date]) <=4,"Term 2",
MONTH('Table'[Date]) >=5 && MONTH('Table'[Date]) <=8,"Term 3",
MONTH('Table'[Date]) >=9 && MONTH('Table'[Date]) <=12,"Term 1")