Forum Discussion
Custom Sort Order for a Measure
I have the following measure which returns the screenshot of data below when applied to a matrix - essentially the date with a little calculation of how many days old the note is. StatusNote...
I meant you can FORMAT the date in your measure.
FORMAT(SELECTEDVALUE(...), "yyyy/MM/dd")
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!!