I have a calendar table where I have a Year field and a boolean field CurrentMonth which shows true if it is current month else false. My fiscal year months starts from July till June.
Right Now I am using a filter to select the current year to show the data. Is it possible to automate this and remove the filter. something like below
CurrentYear = Year where CurrentMonth = True. ( trying to get the Year value for current month) Or Is there is a better way to show current fiscal year data automatically.