Academic Ordering

[Anonymous]

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

[amitchandak · Accepted solution]

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

[Anonymous]

Many thanks for your quick reply @amitchandak 

Thats work perfect.

Thanks again