Forum Discussion

smitpau's avatar
smitpau
Helper I
5 years ago
Solved

Get Current Fiscal Year based on TODAY

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 su...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    HI smitpau 

    Try a measure like this

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

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

HI smitpau 

Try a measure like this

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

Regards

Phil

Jacob_Austin's avatar
Jacob_Austin
Regular Visitor
3 years ago

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