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 🙂
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.
Please expound, I did not understand your solution..