Sort date descending

[azaterol]

Hello everyone,

I sorted the months in descending order as follows:

In Date table created 2 additional columns called 'MonthDesc' and 'MonthDescKey'.

MonthDesc = FORMAT('Date'[Date], "MMM")

MonthDescKey = 32 + (-1*MONTH('Date'[Date]))

Then sort 'MonthDesc' by 'MonthDescKey' (Option: Sort By column)

Now I would like to have the days sorted in descending order. How is that possible?

So that 2. September is first and under that date is 1. September .

[amitchandak · Accepted solution]

@azaterol , Use Rank

example

Date 1 = [Date]

Date Desc = Rankx(Date, [Date],,desc,dense) /use as sort column 

Day = day([Date1])

Day1 = day([Dat1])

Day Desc = Rankx(Date, [Day1 ],,desc,dense) //use as sort column

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[azaterol]

@amitchandak  thank you.