Show fiscal year of today's date based on data model.

[PassionBIdevlpr]

Hello community,

I want to show the fiscal year for today's date based on calendar data model.My fiscal year starts may 1st.I have data from 5/1/2017 to 4/30/2022.

My question is i want show fiscal year for today's date.

Answer is 2024.

How can i write dax for this problem.Thanks in advance

[VahidDM · Accepted solution]

Hi @PassionBIdevlpr 

Add a new column using this DAX:

Fiscal Year Column = 
Var _A = MONTH('Table'[Date])
return
if(_A>4&&_A<=12,year('Table'[Date])+1,YEAR('Table'[Date]))

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube