Sort MonthYear timeintelligence


#1

Hi Sam,

How did you sort Year month as in

Calculating Sales Financial Year to Date in Power BI with DAX - Time intelligence training. I can sort by month but when I use month year, the table sorts by month first then by year. eg 3 January are listed then Feb and so on.

Cheers
e


#2

Hi @ElizabethTachjian,

For this you need a auxiliar column that is in the dates table and sort your months using that table.

Go to the resources for that course and download the pbix file that is already finished there, from there go to the tables and see which column is sorting the MonthYear column. You need to sort that column with the MonthnYear auxiliar column and you do this using the option Sort by Column:

image

Best Regards,

Jorge Galindo


#3

ok. how do I create a month year column to sort in query editor.


#4

Hi @ElizabethTachjian,

You can see how to in this course:

There you will go through query editing for a date table that is created at that course.

Best regards,

Jorge Galindo