Forum Discussion
cottrera
Post Prodigy
Post ProdigyPower 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 = column year 1 else 0
How would you suggest I do this in power query.
thank you
RIchard
NewStep=Table.AddColumn(PreviousStepName,"CustomColumnName",each Byte.From(Date.Year(DateTime.LocalNow())=[the colum name of year in previous step table]))
2 Replies
- wdx223_Daniel
Community Champion
NewStep=Table.AddColumn(PreviousStepName,"CustomColumnName",each Byte.From(Date.Year(DateTime.LocalNow())=[the colum name of year in previous step table]))
cottreraGreat works perfect . Thank you for your quick response