Create Custom Column with multiple IF functions

[Anonymous]

Hi,

I have a table 'PlanYear' that I need to add a new column to.  I need this column to return "Current" if the [PlanYear] column is equal to 2021.  I also need this column to return "Prior" if the [PlanYear] column minus 1 is 2020 and return "Historical" if [PlanYear] is anythng else.

I tried to create the column as follows but it didn't work.  I know I am close but was hoping to get some help.

New Column = IF ( YEAR ( TODAY () ) = 'PlanYear'[PlanYear], "Current", IF ( YEAR ( TODAY () ) = 'PlanYear'[PlanYear] - 1, "Prior", "Historical" ) )

Here is a photo of the table:

[smpa01]

@Anonymousplease change the formatting of Plan Year column to Integer, it is currently formatted as text

[Anonymous]

While that fixed the #ERROR...my 2020 row is returning "Historical" instead of "Prior".  How should I go about resolving that?

[smpa01 · Accepted solution]

@Anonymous  change it to

if (year(today())-1=[planyear],"prior"