This content has been marked as final. Show 2 replies
I am having trouble identifying current fiscal year months within a calculation.
How can I re-create this calculation using Fiscal Year starting at 7/1?
YTD Current Year Only FINAL:
DATEPART('year',[Date])=datepart('year',[Max Date]) and
[Date] <= [Max Date]
THEN [Final Net Back % to display]
Please see workbook for some context and eventual desired output at aggregated level.