Forum Discussion

chonchar's avatar
chonchar
Icon for Helper V rankHelper V
2 years ago
Solved

Custom Fiscal Year with DAX

parry2k Erokor  Good morning,   I have a very large data set spanning 7 fiscal years. I currently have an area chart that visualizes "Total Screens" on the Y-axis and "Year" on the X-axis. See bel...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    chonchar if it is of type date then try to change it to this to see if it works:

     

    Year = 
VAR __Date = 'Table'[Date]
VAR __Year = YEAR ( __Date ) 
VAR __StartDate = DATE ( __Year, 10, 1 ) 
VAR __EndDate = DATE ( __Year + 1, 9, 30 )
RETURN

IF  ( __Date >= __StartDate && __Date <= __EndDate, __Year + 1,  __Year )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

chonchar there is something wrong with the data, very hard to tell what it is? Maybe share your pbix file.

  • chonchar's avatar
    chonchar
    Icon for Helper V rankHelper V
    2 years ago

    parry2k Thanks for the help. I wish I could share it, but there is a ton of secret stuff in here for my job. I am just going to try and change the types until it works, else I will move on and reach out to someone internally. Thank you.