Forum Discussion
Month Sorting in a Matrix
Hello, I have a set of data I want to view comparing results on a month-to-month basis for the last three months. The rows are the various metrics, the columns are the month of the week-endin...
Hi Anonymous ,
If you don't have duplicated month value in your fact table, you can try the following steps:
1. Create the calendar table:
Calendar = ADDCOLUMNS(CALENDAR(DATE(2020,10,1),DATE(2021,1,31)),"Year",YEAR([Date]),"MonthNum",MONTH([Date]),"Month",FORMAT([Date],"mmm"),"YEARMONTH",YEAR([Date])*100+MONTH([Date]))2. Sort the month column by YEARMONTH column:
Then it will show like you want:
But if you have duplicated month value in your fact table, you really need to put year in the column.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
I had one question. If I have months like this
Jan - 2024, feb 2024 etc
How can we sort this in descending order in column in matrix visual