Forum Discussion
Index Question/ Issue
Hi, my data is in a table called Ex Table. I have another table called MonthOrder that is indexed so my dates are in order. The dates are in corrrect ordere in my graph. I want to add a data table...
Hi Anonymous ,
Sorry for my misunderstanding.You could follow these steps to add a Month Number column and then sort by it.
1.Add a Date column
Date =
DATEVALUE ( [Month] )2. Extract Month Number:
Month Number =
MONTH ( [Date] )3. Use "Sort by column" feature:
Finally, the Mon in Matrix will be sorted correctly.
Here is the pbix file.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Again apologies, but in my comment I wrote I need it to go by academic year, so September through to August.