Nested IF with Condition

[Stuznet]

Hi all,

I'm struggling turning this formula in Exel to Power BI

=IF(Date2<>"-",YEAR(Date2),IF(Date3<>"-",YEAR(Date3),IF(Date4<>"-",YEAR(Date4),IF(Date1<>"-",YEAR(Date1),2020))))

The yellow  column is what I want.

Can someone please help? 

Thank you

[Greg_Deckler · Accepted solution]

If this is a calculated column, then it should be:

=IF([Date2]<>"-",YEAR([Date2]),IF([Date3]<>"-",YEAR([Date3]),IF([Date4]<>"-",YEAR([Date4]),IF([Date1]<>"-",YEAR([Date1]),2020))))

[Greg_Deckler · Accepted solution]

If this is a calculated column, then it should be:

=IF([Date2]<>"-",YEAR([Date2]),IF([Date3]<>"-",YEAR([Date3]),IF([Date4]<>"-",YEAR([Date4]),IF([Date1]<>"-",YEAR([Date1]),2020))))

[Stuznet · Accepted solution]

@Greg_DecklerThank you Greg. The solution you posted it work but I slighly edited the function. Because the column is a date type it cannot be text "-" so I replaced with BLANK(). 

Column =IF([Date2]<>BLANK(),YEAR([Date2]),
 	IF([Date3]<>BLANK(),YEAR([Date3]),
	IF([Date4]<>BLANK(),YEAR([Date4]),
	IF([Date1]<>BLANK(),YEAR([Date1]),2020))))