Get Current Fiscal Year based on TODAY

[smitpau]

Hi,

Is there a way to return the current fiscal year based on today's date (so TODAY in DAX).

I've got a calendar table as below with the dates and corresponding Fiscal Year column but not sure how to write the DAX code.

Thanks,

[PhilipTreacy · Accepted solution]

HI @smitpau 

Try a measure like this

Current FY = LOOKUPVALUE('Table'[Fiscal Year],'Table'[Date],TODAY())

Regards

Phil

[Jacob_Austin]

doesn't work, only returns the value into rows with today's date. 

[smitpau]

Great thanks Philip that works.