Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to Solution.
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
NewStep=Table.AddColumn(PreviousStepName,"CustomColumnName",each Byte.From(Date.Year(DateTime.LocalNow())=[the colum name of year in previous step table]))