Forum Discussion
wenners68
Helper II
Helper IIOrder 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 :-)
wenners68Helper II
Helper IIThanks,
Do I add the FYMonthNum column to the Date table or to the table with the sales data?
RolandsP
Resolver IV
Resolver IVIn a Date table
- wenners68
Hi, 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...