Forum Discussion

wenners68's avatar
wenners68
Helper II
8 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • RolandsP's avatar
    RolandsP
    8 years ago

    Formula should be:

     

    Financial month number = IF(DateKey[Month number]-4<=0,DateKey[Month number]+8,DateKey[Month number]-4)

  • wenners68's avatar
    wenners68
    8 years ago

    Thanks, that does it :-)

RolandsP's avatar
RolandsP
Resolver IV
8 years ago

Formula should be:

 

Financial month number = IF(DateKey[Month number]-4<=0,DateKey[Month number]+8,DateKey[Month number]-4)

wenners68's avatar
wenners68
Helper II
8 years ago

Thanks, that does it :-)