cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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! 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

9 REPLIES 9
Super User IV
Super User IV

@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

Sort_by_column.pngSortnewribbion.png

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Anonymous
Not applicable

Thank you very much! It works perfectly! 

Super User IV
Super User IV

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.

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

My bad. I will check the link out. 

 

It gives me an error. Any idea why?

 

Capture.JPG

Sorry, meant:

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

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Frequent Visitor

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
Not applicable

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

Capture1.JPG

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Change ; by ,

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors