Forum Discussion

JessicaM's avatar
JessicaM
Frequent Visitor
5 years ago
Solved

Customize fiscal year

Hi all!   I built the Fiscal Year starting on sept 1st and finishing on oct 30th. Here is the calculated field that I created and till a few days ago, it was working fine: Fiscal Year = IF(AND([Ye...
Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    JessicaM ,

     

    Here's a long-term solution to dynamically generate this field, for fiscal year starting September 1st:

     

     

    _fisYear = 
IF(
    MONTH(Calendar[date]) <= 8,
    "FY" & RIGHT(YEAR(Calendar[date]) - 1, 2) & "-" & RIGHT(YEAR(Calendar[date]), 2),
    "FY" & RIGHT(YEAR(Calendar[date]), 2) & "-" & RIGHT(YEAR(Calendar[date]) + 1, 2)
)

     

     

    Pete 

BA_Pete's avatar
BA_Pete
Super User
5 years ago

Hi JessicaM ,

 

From your error message, it looks like there are full stops (periods/dots) in between the AND() arguments, rather than commas:

 

This would confuse Power BI. Oddly, this doesn't correspond with the calculated field code you posted previously.

Can you check that the actual field code doesn't have these full stops?

 

Pete

JessicaM's avatar
JessicaM
Frequent Visitor
5 years ago

That is correct. The code above is not the same like the error message but is exactly what I have in my screen... please see the screenshot: