How to sort my fiscal month column e.g. JUL 01 , AUG 01

[mimigabriel]

Hello Power bi Coummuntiy 

I real want to sort the fiscal month column e.g 

JUL 01 , AUG 01 ,SEP 01, OCT 01, NOV 01, DEC 01 then it continue  like jan 02 feb 02

Fiscal Month Number =

IF (

Sales[Month Number] > 6,

Sales[Month Number] - 6,

Sales[Month Number] + 6

)

by creating the above column i sorted the fiscal month. and the output is as shown bleow how can i convert this to the above example. Thank you in advance for your support. 

[v-yangliu-msft · Accepted solution]

Hi  @mimigabriel ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Fiscal Month =
FORMAT('Table'[Date],"mmm") &" "& FORMAT('Table'[Date],"dd")

rank =
FORMAT([Date],"ddmm")

2. Create calculated table.

Table 2 = SUMMARIZE('Table','Table'[Date],'Table'[Fiscal Month],'Table'[rank])

3. Click [Fiscal Month] – sort by column – [rank].

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[mimigabriel]

Thank you so much was very helpful

[mimigabriel]

@amitchandak  

thank you for your quick replay

but the output i want to see is as follow JUL 01 , AUG 01 ,SEP 01, OCT 01, NOV 01, DEC 01 then it continue  like jan 02 feb 02

please let me know if you have any idea 

thank you 

[amitchandak]

@mimigabriel , this for a month name

Month= FORMAT([Date],"mmm")
Month sort = if(month([Date]) <=6, month([Date]) +6 ,month([Date]) -6)

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort =if(month([Date]) <=6, year([Date]) -1 ,Year([Date])) *100  + if(month([Date]) <=6, month([Date]) +6 ,month([Date]) -6)