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've created a Date table using DAX that has columns for Date, Year, Month and Day.
I want to create a new column called "Winter" that will have values as either:
- "Southern Hemisphere" for May - September
- "Nothern Hemisphere" for November - March
- "Not Winter" for April and October
Can someplease please help with the DAX?
Best,
Soph
Solved! Go to Solution.
Hi @SophRow
Give this a try.
Winter = SWITCH(
TRUE(),
MONTH(Dates[Date]) IN {5,6,7,8,9}, "Southern Hemisphere",
MONTH(Dates[Date]) IN {11,12,1,2,3}, "Northern Hemisphere",
"Not Winter"
)
You would add this as a calculated column to your Dates table.
Hi @SophRow
Give this a try.
Winter = SWITCH(
TRUE(),
MONTH(Dates[Date]) IN {5,6,7,8,9}, "Southern Hemisphere",
MONTH(Dates[Date]) IN {11,12,1,2,3}, "Northern Hemisphere",
"Not Winter"
)
You would add this as a calculated column to your Dates table.
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 |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |