Forum Discussion
smc1906
5 years agoFrequent Visitor
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 act...
- 5 years ago
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
dkaushik
5 years agoResolver 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 Community
If 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
smc1906
5 years agoFrequent Visitor
Thank you so much!