Forum Discussion
Solved
Order column chart by month over multiple years
I'm trying to order the columns by month over a financial year that starts in May and finishes in April. Most examples I have come across only deals with January to December scenarios. Any ideas ho...
Formula should be:
Financial month number = IF(DateKey[Month number]-4<=0,DateKey[Month number]+8,DateKey[Month number]-4)
Thanks, that does it :-)
Yes, you're correct. I used the following calculation to get the financial month:
Financial month number = IF(DateKey[Month number]-4<=0,DateKey[Month number]+4,DateKey[Month number]-4)
Problem being that my financial starts in May (month #5) and finishes in April (month #4), so the calc above won't cope with that scenario.