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")
Hi send you one example new column en Calendar Table: I don't know if that it's what you need.
MONTH L2 = FORMAT('Date'[Date];"mmmm") & " " & 'Date'[Year]
Please confirm me.
Hi thank you for your help. Unfortunately, it gives me an error message like this.
- amitchandak
Super User
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")
Change ; by ,