Forum Discussion
Academic Ordering
Hi,
I'm trying to get my matrix months to start at September as 1 and end at August as month 12.
When I try to order by my academic ordering column it displays the image below. I also cant create a conditional column in power query because it doesnt have my date table in it.
Is there a way around this?
Thanks in advance
Liam
You have to create a new column
Month sort = if(month([Date])<9, month([Date])+4,month([Date])-8)
and mark this as sort column
Refer:https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Also, check my calendar which I created for Apr-Mar, you can take it and make it sep-Aug
https://www.dropbox.com/s/wrcyk5j66corvjg/Apr2Mar-Cal.pbix?dl=0
2 Replies
You have to create a new column
Month sort = if(month([Date])<9, month([Date])+4,month([Date])-8)
and mark this as sort column
Refer:https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Also, check my calendar which I created for Apr-Mar, you can take it and make it sep-Aug
https://www.dropbox.com/s/wrcyk5j66corvjg/Apr2Mar-Cal.pbix?dl=0