getting Month of year starting from September to August

[NnIc0]

Hello guys,

I would like to have my date starting from september to august (to do a fiscal year)

Does somebody know how i can do it ?

Thanks 

Have a good day

[v-deddai1-msft · Accepted solution]

Hi @NnIc0 ,

You can create a calendar table by  Calendar function. And create a custom fiscal year number sort column:

FYMonthNum =

          VAR FYStartMonth = 12

          //Update the fiscal year starting month above *Use number between 1 to 12

          RETURN

IF (

                    MONTH ( Dates[Date] ) >= FYStartMonth,

                    MONTH ( Dates[Date] )

– ( FYStartMonth – 1 ),

12

+ (

                         MONTH ( Dates[Date] )

– ( FYStartMonth – 1 )

)

)

Sort the month column in calendar table by the custom column and create relationship between your fact table and calendar table.

For more details, please refer to https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/

Best Regards,

Dedmon Dai

[amitchandak]

@NnIc0 , Please find

https://www.dropbox.com/s/fwys71ccx5mquxx/Sep_2_Aug_Cal.pbix?dl=0