Financial year Dax

[Anonymous]

Hi,

I need the DAX formulas for my Custom Financial year.

I have a change in my financial year

From 2015-2020, Eg: my financial year is Dec 2015 - Nov 2016 and dax formula should have to display like FY 2016

From 2021 my financial year starts from Jan 2021 - Dec 2021 and dax formula should have to display like FY 2021

Thanks

[amitchandak · Accepted solution]

@Anonymous , In you date table have this- New column

FY = "FY " &  year(Endofyear([Date], "11/30")) // Refer: https://www.youtube.com/watch?v=LbstAOFD2Vo

or

FY = "FY " &  year(Endofyear([Date], "12/31"))

put a if condition to check year and shift between

Creating Financial Calendar - From Any Month (All 12 months calendar)
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

[harshnathani · Accepted solution]

Hi @Anonymous ,

With all credit to @amitchandak  reply.

What will be FY for Dec 2020 ? Assuming it will be FY 2021.

FY = 
if ('Date'[Year] <= 2021,
"FY " &  year(Endofyear('Date'[Date], "11/30")),
"FY " &  year(Endofyear('Date'[Date], "12/31"))
)

Please find solution attached.

[amitchandak · Accepted solution]

@Anonymous , In you date table have this- New column

FY = "FY " &  year(Endofyear([Date], "11/30")) // Refer: https://www.youtube.com/watch?v=LbstAOFD2Vo

or

FY = "FY " &  year(Endofyear([Date], "12/31"))

put a if condition to check year and shift between

Creating Financial Calendar - From Any Month (All 12 months calendar)
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441