Forum Discussion
How to Create a Month Year Column in Calendar
Hello all, I am trying to find a formular to create a mont year column (eg: November 2019, December 2019) that can also be sorted chronoically (eg: November 2019, December 2019, Janauary 2020, F...
Anonymous ,
Why are giving column = Month Year = format([Date],"mmmm yyyy")
you have to give only
Month Year = format([Date],"mmmm yyyy")
or
Month Year = format([Date];"mmmm yyyy")
Create a month year sort column
Month year Sort = format([Date],"YYYYMM")
amitchandak
Super User
Super UserAnonymous
Create a column month year
Month Year = format([Date],"mmmm yyyy")
Create a month year sort column
Month year Sort = format([Date],"YYYYMM")
Mark this new sort column as sort column of the month year
Refer:https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Thank you very much! It works perfectly!