Forum Discussion
Custom date format
Hi JennaExe ,
You have created MonthYear column.
Now create a new column by this formulaSortkey = FORMAT('Date'[Date], "yymm")Then sort your month year column by this SortKey column.
SortingOutput
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hello JennaExe ,
it won't be recognized as a date column, it will be recognized as a text.
If the issue is the ordering you can make a sorting for this text you're using Sort = FORMAT (‘Table name'[Date], “MMYY”). then use it to sort the text column.
Hello, many thanks for replying - I don't generally use DAX as I don't understand how it works yet - would you be able to elaborate a bit on exactly what I need to do, as the formula you've suggested looks the same as the one I'm already using, except you've called it 'sort' - how does this make a difference, how does it work? Is this something I put in as another column, or instead of my one? Sorry for being so ignorant! Thank you!
Hello JennaExe ,
I got you an easier approach, sort the column you made by date as in the screenshot
Thank you, but sorting the column in Reports doesn't impact on how the dates sort in my graphs, they are still alphabetical??
