You can order date dimension in descending order by setting OrderByAttribute property

Written by Patrice Truong. Posted in SSAS Tips

Analysis Services does not provide a way to sort dimension members in DESCending order, only in ASCending order. Fortunately, this sort functionality is easy to implement, using the Data Source View.