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
Anonymous , Mark the datetime column (or take out from this column) and mark that sort column for Status Not Date
Hey amitchandak, thanks for your reply.
Unfortunately Status Note Date Formatted is a measure which is the column you see in the visual (Status Note Date). I was under the impression you can't define a column to sort a measure by.