Forum Discussion
Helper IIOrder column chart by month over multiple years
Formula should be:
Financial month number = IF(DateKey[Month number]-4<=0,DateKey[Month number]+8,DateKey[Month number]-4)
Thanks, that does it :-)
Helper IIHi, that doesn't work.
This is what I've done so far: I've created a date table with a variety of columns, including MonthY (Year+Month number), related the sales table and the date table. I then try to sort Month by using the MonthY field. And this is what I get:
This is how the date table looks like (a cut down version):
I've also tried sorting by the Index field, with the same error result. I expected this to be something that was easy to do, but it's proving surprisingly hard...
Resolver IVYou have field Financial Month Number. Sort Month column by that field.
- wenners68
Nope
- RolandsP
Then you need to check value in this field. Based on the chart you sent for Jan you have number 5, although it should be 9.
- wenners68
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.