Forum Discussion
Solved
Financial Periods
I have written this formula to display my financial period, but it is not working:
The periods should run as follows:
01/07/2018 - 201801
01/08/2018 - 201802
Our financial year is from July to June, running period 1 to 12
Regards,
Use this formula
= FORMAT(EDATE('Date Table'[Date],-6),"YYYYMM")
1 Reply
Use this formula
= FORMAT(EDATE('Date Table'[Date],-6),"YYYYMM")