EVALUATE with a different ORDER BY column

[MarkH]

In DAX Studio, this works:

EVALUATE
ADDCOLUMNS(
            VALUES('Date'[MMMYYYY])
                    ,"Tested Measure",[Total Sales]
)

But is doesn't sort correctly even though, in the model, Date'[MMMYYYY] is sorted by 'Date'[MMMYYYY sort]

This errors:

EVALUATE
ADDCOLUMNS(
            VALUES('Date'[MMMYYYY])
                    ,"Tested Measure",[Total Sales]
)
ORDER BY
'Date'[MMMYYYY sort]

Error = 'A single value for the column 'Date'[MMMYYYY sort] cannot be determined....'

The only difference is the ORDER BY. I assume it errors because the sort column is not in the result set.

Straightforward in SQL but surely there has to be a way round this in DAX?

Please explain.

[Anonymous]

The simplest explanation of all is that the column by which you want to sort must be included in the result set. Easy as that.

Best
D.