If date field is this year

[Anonymous]

Hi all,

We have a company table containing a date field called "Onboarding Date".

I want to make a calculated column based on that date to be like this:

If Onboarding Date is blank OR in current year; "New"; "Existing".

However, I am not sure how to make this.

Thanks for the help 🙂

[bakerm00]

since i've gone thru the pain of learning this today. 

determines if an end date is in this year or next (for a gantt visual filter)

= Table.AddColumn(#"convert progress to percent", "ganttyearfilter", each if([Forecast End Date] is null) then "0" else if(Date.IsInCurrentYear([Forecast End Date])) then "1" else if(Date.IsInNextYear([Forecast End Date]))then "2" else "99")

[amitchandak]

create a new column

New Vs Exiting = 
IF( (ISBLANK([Onboarding Date]) || YEAR([Onboarding Date]) = YEAR(TODAY()) ),"New","Existing"
)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[SivaMani]

@Anonymous,

Here you go,

Onboarding Type = IF(OR(ISBLANK('Table'[Onboarding Date]),YEAR( 'Table'[Onboarding Date] = YEAR(TODAY()))),"New", "Existing")

Let me if any issue or need any help!

Regards,

Siva Mani

[az38 · Accepted solution]

Hi @Anonymous 

try column

Column = 
IF( 
OR(ISBLANK([Onboarding Date]), YEAR([Onboarding Date]) = YEAR(TODAY()) ),
"New",
"Existing"
)

do not hesitate to give a kudo to useful posts and mark solutions as solution