The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all,
I want to split my finaincal year, which is going from 01.10.YYYY until 30.09.YYYY+1, into two different Seasons. To be more precise into "Summer 21/22" and "Winter 21/22".
The Code which gives me the finanical years like FY 21/22 works quite well.
Solved! Go to Solution.
hi @Till__
try like:
Season =
VAR fy =
IF (
MONTH ( 'Calendar'[Date] ) <= 3,
VALUE ( FORMAT ( 'Calendar'[Date], "YY" ) ) - 1 ,
VALUE ( FORMAT ( 'Calendar'[Date], "YY" ) )
)
VAR _season
IF (
MONTH ( 'Calendar'[Date] ) >=3&& MONTH ( 'Calendar'[Date] )<=8,
"SS ", "FW "
)
RETURN
_season&fy
hi @Till__
try like:
Season =
VAR fy =
IF (
MONTH ( 'Calendar'[Date] ) <= 3,
VALUE ( FORMAT ( 'Calendar'[Date], "YY" ) ) - 1 ,
VALUE ( FORMAT ( 'Calendar'[Date], "YY" ) )
)
VAR _season
IF (
MONTH ( 'Calendar'[Date] ) >=3&& MONTH ( 'Calendar'[Date] )<=8,
"SS ", "FW "
)
RETURN
_season&fy
Thank you! This perfectly works 🙂
For me to work there is only one minor mistake as your code includes march but it should stop in feburary to be FW as written above but this is not important!
MONTH ( 'Calendar'[Date] ) < 3
Thank you so much 🙂