Forum Discussion
Sort by Column does not work
Hi , I am trying to sort the data by month in my visualization, and it is sorting alphabetically. So I created a column in my data table call sort and try to use the Sort by Column to sort it cor...
No, that is a text field. I used Concat function in sql
MAX(CONCAT(LEFT(DATENAME(MONTH,ARPB_TRANSACTIONS_PAYMENT.POST_DATE),3),' ',(RIGHT(YEAR(ARPB_TRANSACTIONS_PAYMENT.POST_DATE),2)))) AS 'POST_MONTH_AND_YEAR'
cy2452 If you change it to a date field it should sort properly, you might have to use a Format function in your DAX