Power Query - Of current year = Column Year

[cottrera]

Hi 

I have a table that contains columns of years.  So that I can add some conditional formating these ciolumns I would like to add a custom column that uses an if statement 

If current year = column year 1 else 0

How would you suggest I do this in power query.

thank you 

RIchard

[cottrera]

Great works perfect . Thank you for your quick response

[wdx223_Daniel · Accepted solution]

NewStep=Table.AddColumn(PreviousStepName,"CustomColumnName",each Byte.From(Date.Year(DateTime.LocalNow())=[the colum name of year in previous step table]))