topic Re: How to sort my fiscal month column e.g. JUL 01 , AUG 01 in DAX Commands and Tips

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

mimigabriel — Tue, 10 May 2022 21:09:58 GMT

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.

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

amitchandak — Wed, 11 May 2022 01:33:04 GMT

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)

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

mimigabriel — Wed, 11 May 2022 06:35:43 GMT

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

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

Anonymous — Fri, 13 May 2022 04:11:12 GMT

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

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

mimigabriel — Fri, 13 May 2022 05:53:32 GMT

Thank you so much was very helpful