Forum Discussion
Solved
Power Query - Of current year = Column Year
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 ...
NewStep=Table.AddColumn(PreviousStepName,"CustomColumnName",each Byte.From(Date.Year(DateTime.LocalNow())=[the colum name of year in previous step table]))
Great works perfect . Thank you for your quick response