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")
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |