Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I try this, but it give me my month in alphabetic orderL April, August, .......
but me, I want January, febuary, ......
Month = switch(month('table'[date]),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December"
)
Solved! Go to Solution.
@game1 , Create two columns in you table , if you don not have already
Month Name = format([Date], "MMMM")
Month Sort = Month([Date])
Select the first column, go to column tools and use Sort by column and use Month Sort
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
@game1 , Create two columns in you table , if you don not have already
Month Name = format([Date], "MMMM")
Month Sort = Month([Date])
Select the first column, go to column tools and use Sort by column and use Month Sort
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |