Forum Discussion
Fiscal year period sorting
Hi Guys , We have a fiscal year Jul to Jun, - in the format tab I'm not able to sort graphs of tables by the sequence of months form Jul to Jun In trying to fix/resolve this in the data tab I've ...
Here's my solution:
1. Duplicate Date Column
2. Split Column by Delimiter (however your date is formated, I split by each occurrence of /)
3. Delete the column with the days, since the months are the only thing that I'm concerned about
4. Exit Query Editor
5. Right click on the table that you are interested in, choose 'New Column')
6. Essentially you create a measure that says if the month is between x and y then produce the year, if not, produce year-1. Here's mine for fiscal year July x+1 through June x:
Fiscal Year = IF('Transactions FY11 to FY18'[Date Month]<7,'Transactions FY11 to FY18'[Date Year], 'Transactions FY11 to FY18'[Date Year]-1)