Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |