sort date month+year

[Anonymous]

Hello, 

I've got my date slicer : 

Month+Year 

For example : 

January 2018

February 2018

March 2018

April 2018

April 2019

May 2018

May 2019

My column "MonthYear" is sorted by month number. 
I do not understand how to sort this date. It's really important to have Month by Month et year by year, I don't want years to be mixed!

Thanks by advance for ur help, I researched but I didn't really find an answer to this specific question..

Have a nice evening!

[calerof · Accepted solution]

Hi @Anonymous ,

Create a new column in your date table for year month as follows:

YearMonthNum = FORMAT( [Date], "YYYYMM")

Then sort your column YYYY-MMM by YearMonthNum.

Regards,

Fernando

[Anonymous]

Thanks so much ! Have a nice day