Forum Discussion
Solved
Order matrix collum month year
Im having another struggle, i want do order this collums of the matrix from 2023-04, 2023-03, 2023-02 ,so on, i tried by query, the near i got was as the image. i have a collum named YearMon...
You can add a new column to your date table with an expression like this
MonthsFromNowReverse = DATEDIFF([Date], TODAY(), MONTH)and then use it as the Sort By column for your YYYY-MM columnPat
ppm1
Solution Sage
Solution SageYou can add a new column to your date table with an expression like this
MonthsFromNowReverse = DATEDIFF([Date], TODAY(), MONTH)
and then use it as the Sort By column for your YYYY-MM column
Pat
Thank you,
Just need to create one more column so that this solution could work. If i didnt it would give me an error that it was sorting by ir self.
