How to Create a Month Year Column in Calendar

[Anonymous]

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! 

[amitchandak]

@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

[Anonymous]

Thank you very much! It works perfectly! 

[Greg_Deckler]

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.

[Anonymous]

My bad. I will check the link out. 

It gives me an error. Any idea why?

[Greg_Deckler]

Sorry, meant:

MonthYear = MONTH([Date]) & YEAR([Date])

[julioms23]

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.

[Anonymous]

Hi thank you for your help. Unfortunately, it gives me an error message like this. 

[amitchandak · Accepted solution]

@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")

[julioms23]

Change ; by ,