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")
Greg_Deckler
Community Champion
Community ChampionPlease 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.
My bad. I will check the link out.
It gives me an error. Any idea why?
- Greg_DecklerSorry, meant:
MonthYear = MONTH([Date]) & YEAR([Date])