Sorting months in fiscal calendars in DAX

[dsfshshfhgsghs]

Alberto, tante grazie por tus clases. Estoy aprendiendo muchísimo con tus clases (y las de Marco también, por supuesto). You both are very generous for giving us such fantastic content for free (I think of your online courses at SQLBI's web too, not only these videos). Thank you very much! Saludos desde Buenos Aires, Argentina!

[vlogniten]

thank you for this tutorial. been trying to figure this out and you tutorial is so easy to follow for newbie like me in power bi

[lindabond]

As if our lives were not difficult enough but .... Fiscal Month. Thanks for this!

[amadiftikhar]

Just what i was looking for. Hats off Alberto great explanation.

[pleblanc]

Sometimes we need a refresher. Great video @alberto!!!!

[lindabond]

I'm back again, looking over this info. I'm creating a independent date hierarchy (FY / FY Month Year / Date) and now I need to sort the FY Mth Year. I guess I have to create Month plus Year value though it's not so straight forward...Happy holidays to you!
(And I did find a solution - it was much easier in PQ - I created a cust col with Date.StartofMonth and then converted that to a whole number, and used that to sort my Mth/Years)

[elenakanina]

Thanks for your Great Job. You are GURU more me!!!

[ImranHussain-xvse]

Alberto, thanks for sharing valuable information

[mchopra]

In my case fiscal month starts from December, what formula should I apply?

[gondebas]

Hi Alberto, have you ever covered the topic of dynamic toggling by the user between Calendar and Fiscal years? I mean displaying the sales by months, either calendar or fiscal months, according to user choice. I tried to do it with Field Parameters however it always collapses Months in the matrix to full Years. And the Field Parameters do not seem to allow changing sort of Months as you demonstrated in the video. The only way left is bookmarks, however this is a "dirty" approach.

[woodywood]

Hello, How can we get a YTD out of that? I can't add my Variable "Fiscal Months" to my formula as it is not considered as a date=> YTD = CALCULATE (SUM('YTD Test'[Actual Sales Turnover]), DATESYTD('YTD Test'[Date for YTD].[Date]))

thanks

[sujkubvs]

Hi Alberto, Thanks for the video, it really helped me a lot, but one question > How to get month name as "mmm" in the Fiscal month?

[etclner]

This is incorrect and will fail if you have any month greater than June(6). Try to run this DAX for any starting month JULY(7) to DECEMBER(12) and check on the "Fiscal Month Number".

The proper solution when suppose the start month is OCTOBER(10):
Fiscal Month Number = IF('Date'[Month Number] > 9, 'Date'[Month Number] - 9, 'Date'[Month Number] + 3)