Forum Discussion

smitpau's avatar
smitpau
Icon for Helper I rankHelper 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 sure how to write the DAX code.

 

 

Thanks,

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

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    HI smitpau 

    Try a measure like this

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

    Regards

    Phil

    • smitpau's avatar
      smitpau
      Icon for Helper I rankHelper I
      5 years ago

      Great thanks Philip that works.

    • Jacob_Austin's avatar
      Jacob_Austin
      Regular Visitor
      3 years ago

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