Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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")
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")
User | Count |
---|---|
106 | |
90 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |