Forum Discussion
Sort date descending
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 .
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
2 Replies
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-camitchandak thank you.
