If Statement With Dates

[WJ876400]

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/2020	Term 2
01/02/2020	Term 2
01/03/2020	Term 2
01/04/2020	Term 2
01/05/2020	Term 3
01/06/2020	Term 3
01/07/2020	Term 3
01/08/2020	Term 3
01/09/2020	Term 1
01/10/2020	Term 1
01/11/2020	Term 1
01/12/2020	Term 1

thanks

[Gordonlilj · Accepted solution]

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")