Change a Year to Academic Year String eg. 2016 -> 2016/17

[cwfmoore]

I have a date table I use for an academic organisation.  The academic year application process starts on October 1st.

I would like a text column which displays the appropriate academic year in this format "2016/17".

To clarify 2016/17 would run from 1st October 2016 to 31st September 2017 then increment up to 2017/18 from the 1st October 2017 and so on.

My date table is imaged below, so far I have only added 1 to the year value, but I have no idea how to get the result I want.

Any assitance would be greatly appreciated.

[cwfmoore]

Perfect, thanks for your help! 😁

[Vijay_A_Verma · Accepted solution]

Use below formula

= Text.From(if [Month Num]>=10 then [Year] else [Year]-1)&"/"&Text.End(Text.From(if [Month Num]>=10 then [Year]+1 else [Year]),2)