Forum Discussion
Sort Month Year Column Dax
I have a custom column:
Month Year = FORMAT('DimDate'[Date],"MMM YYYY")
Is there a way to sort this column other than the "Sort by Column" tab in the ribbon? i.e. is there a DAX formula I can use like I would for weekday
Day of the Week Sort = WEEKDAY([DATE_START],2)
Anonymous
Create a sort column in the same table as
Month Year Sort = FORMAT('DimDate'[Date],"yymm")
Then, use Sot By column and choose this new sort column.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
1 Reply
Anonymous
Create a sort column in the same table as
Month Year Sort = FORMAT('DimDate'[Date],"yymm")
Then, use Sot By column and choose this new sort column.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂