Forum Discussion
Adding a seasons column to dates table based on month dates
Hi everyone,
I'm relatively new to PowerBI but thanks to this site my first reports are already working great.
Unfortunatly I couldn`t find any solution for this minor problem...
I'm generating my dates table like this:
Now I would like to add a Column that shows the coresponding "Season"
Seasons are starting on July, 01 every year and ending on June, 30 the year after
So for example:
July, 01 2017 - June, 30 2018 = Season 2017-2018
July, 01 2018 - June, 30 2019 = Season 2018-2019
July, 01 2019 - June, 30 2020 = Season 2019-2020
Thanks in advance for any help
HI Benji_964 ,
Try and create a Calculated Column.
Season Year = VAR _season = IF ( MONTH ( 'Dates'[Dates] ) <= 7, VALUE ( FORMAT ( 'Dates'[Dates], "YYYY" ) ), VALUE ( FORMAT ( 'Dates'[Dates], "YYYY" ) ) - 1 ) RETURN CONCATENATE ( "SEASON", CONCATENATE ( _season, CONCATENATE ( "/", _season + 1 ) ) )Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
2 Replies
HI Benji_964 ,
Try and create a Calculated Column.
Season Year = VAR _season = IF ( MONTH ( 'Dates'[Dates] ) <= 7, VALUE ( FORMAT ( 'Dates'[Dates], "YYYY" ) ), VALUE ( FORMAT ( 'Dates'[Dates], "YYYY" ) ) - 1 ) RETURN CONCATENATE ( "SEASON", CONCATENATE ( _season, CONCATENATE ( "/", _season + 1 ) ) )Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi Anonymous,
thank you for your help and the fast reply.
Your solution workes grate!
Had to make only some minor changes.
"<=6" instead of "<=7" and put the "-1" after the first instead of the second value.
Here my solution:
Brennjahr = VAR _season = IF ( MONTH ( 'Datumstabelle'[Date] ) <= 6, VALUE ( FORMAT ( 'Datumstabelle'[Date], "YYYY" ) ) -1, VALUE ( FORMAT ( 'Datumstabelle'[Date], "YYYY" ) ) ) RETURN CONCATENATE ( _season, CONCATENATE ( "-", _season + 1 ) )Thank you very much!
