Forum Discussion
Custom Sort Order for a Measure
I meant you can FORMAT the date in your measure.
FORMAT(SELECTEDVALUE(...), "yyyy/MM/dd")
Pat
It is sorting alphabetically (descending). You can FORMAT your date as "MM/dd/yyyy" so that the zeros show up and you get the needed order.
Pat
Hi ppm1 thanks for your response. So the sort by column (StatusNoteDate) I changed the date format to "MM/dd/yyyy". I can't format the calculated column (StatusNoteDate&DaysOld) that way since I am adding a string, it can't be both date and string. But if I sort the Calculated column by StatusNoteDate, it sorts in the correct order in data view but is still going alphabetical in the visual.
I meant you can FORMAT the date in your measure.
FORMAT(SELECTEDVALUE(...), "yyyy/MM/dd")
Pat
Oh I understand now, thank you. This works!!