The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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]))