I am trying to create two columns " End of period " and " Start of Period" for every single date in my table ( for Financial year ). I primarily trying to use MAX ( date) and MIN (date) for them but it doesn’t make any sense
Could you please advise on it how to get this result.
example below :