Forum Discussion
Sort a Month Year Column
I am trying to sort a column called MOnth Year Num. How can I create a column to sort it? I have a Bar chart that shows the last 3 months. So I want to sort that column so that October 2...
Hi,
One of ways to create a sort column for the Month Year Num column is to create a ENDOFMONTH column by using a DATE column and EOMONTH DAX formula.
EOMONTH function (DAX) - DAX | Microsoft Learn
I hope this helps.
- Month and Year = FORMAT([Date], "YYYY") & MONTH('Calendar'[Date])try this, let me know if it works 🙂
Anonymous,
you can create a Date_start column as below.
then create a copy of the "month year num" column and use the Date_start column to sort. We create the copy of the column to ensure that you wont get the circular dependancy error.
then use the newly created copy of the column in your chart as below.