Hi Rohan! Just to be sure, what is the first month of your fiscal year? And can you upload a packaged workbook for us to see?
In general, I think the easiest way to calculate the beginning of the fiscal year is to subtract the number of months in the latter year and then grab the resulting year and use that to build the date. For instance, let's say that your fiscal year starts in July and you're working with an extract. You could do this:
MAKEDATE(YEAR(DATEADD('month', -6, [The Date])), 7, 1)
Thanks for your reply David, Fiscal year is April to March.
I cant able to share the package workbook due to confidential information.
I tried this but its not giving me expected output.
Could you post the exact version of this calculation that you tried to use?