The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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!
Solved! Go to 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")
@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
Thank you very much! It works perfectly!
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
My bad. I will check the link out.
It gives me an error. Any idea why?
Hi send you one example new column en Calendar Table: I don't know if that it's what you need.
Please confirm me.
Hi thank you for your help. Unfortunately, it gives me an error message like this.
@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 ,
User | Count |
---|---|
158 | |
109 | |
96 | |
84 | |
75 |
User | Count |
---|---|
157 | |
137 | |
131 | |
81 | |
61 |