Forum Discussion
Custom Date Sort
Hello,
I have the below date table:
I can sort the Months by "MonthNumber" which is great, but I actually need to sort by a different order. I am working from September to August, so I actually need September to be month number 1. How can I add a custom sort order column to this table, so I can define September as month 1?
Thanks!
Hi, smc1906
You need to define a calculated column, "FiscalMonthNumber" which starts from Sep to Aug.
Follow these steps:
Solved: How to assign fiscal month number - Microsoft Power BI CommunityIf this post helps, then please consider Accept it as the solution and give thumbs up to help the other members find it more quickly.
Thanks,
Dheeraj
2 Replies
- dkaushikResolver II
Hi, smc1906
You need to define a calculated column, "FiscalMonthNumber" which starts from Sep to Aug.
Follow these steps:
Solved: How to assign fiscal month number - Microsoft Power BI CommunityIf this post helps, then please consider Accept it as the solution and give thumbs up to help the other members find it more quickly.
Thanks,
Dheeraj
- smc1906Frequent Visitor
Thank you so much!