Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Individual Season Calendar if date is in range
01-23-2023
05:09 AM
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.
Financial Year =
VAR fy =
IF (
MONTH ( 'Calendar'[Date] ) <= 9,
VALUE ( FORMAT ( 'Calendar'[Date], "YY" ) ) - 1,
VALUE ( FORMAT ( 'Calendar'[Date], "YY" ) )
)
RETURN
CONCATENATE ( "FY", CONCATENATE ( fy, CONCATENATE ( "/", fy + 1 ) ) )
My Question is now, how do I split the Code to get also an additonal season parameter? That is I want to have it like this if the date is in the range
FW 21 = 01.09.21 - 28.02.22
SS 22 = 01.03.22 - 31.08.22
FW 22 = 01.09.22 - 28.02.23
SS 23 = 01.03.23 - 31.08.23
FW 23 = 01.09.23 - 28.02.24
Thank you in advance!
My Question is now, how do I split the Code to get also an additonal season parameter? That is I want to have it like this if the date is in the range
FW 21 = 01.09.21 - 28.02.22
SS 22 = 01.03.22 - 31.08.22
FW 22 = 01.09.22 - 28.02.23
SS 23 = 01.03.23 - 31.08.23
FW 23 = 01.09.23 - 28.02.24
Thank you in advance!
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023
05:46 AM
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
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023
05:46 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023
07:32 AM
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 🙂
