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 ...
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 🙂
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 🙂