Sort Month Year Column Dax

[Anonymous]

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)

[Fowmy · Accepted solution]

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

YouTube  LinkedIn