Forum Discussion
Create Custom Column with multiple IF functions
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:
Anonymous change it to
if (year(today())-1=[planyear],"prior"
3 Replies
Anonymousplease change the formatting of Plan Year column to Integer, it is currently formatted as text
Anonymous change it to
if (year(today())-1=[planyear],"prior"