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, February 2020) from my data calendar.
I have checked out some suggestions here such as 1, 2, 3, 4 but none of them is working for me. I have also tried to find a DAX functions but it only has a month or a year function seperately.
Thank you!
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")
9 Replies
- amitchandak
Super User
Anonymous
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
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.
- amitchandak
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")
- Greg_Deckler
Community Champion
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But, should be something like:
Column = MonthYear = MONTH([Date]) & YEAR([Date])
or
Column = FORMAT([Date],"MMMM YYYY")There are lots of options.- Greg_DecklerSorry, meant:
MonthYear = MONTH([Date]) & YEAR([Date])
