Forum Discussion

BishwaR's avatar
BishwaR
Helper V
5 years ago
Solved

New Date Column

I need to create a new Product Expiration column in power query ( No Dax)   I have an existing Product Expiratioin column but besides that I need to create a new Product Epiration column where all ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Table.AddColumn (LastStepName, "Expiration Date", each if [DateColumn] >= Date.AddDays(Date.From(DateTime.LocalNow()), -90) then Date.AddDays(Date.From(DateTime.LocalNow()), +90) else [DateColumn])

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
5 years ago

You need just one parentheses at the end. 

BishwaR's avatar
BishwaR
Helper V
5 years ago

Sorry I just realised it is changing the date for all the Expiration dates I just wanted to change the date for next 90 days only so how to write and && conditiion like   "Expiration Date", each if [DateColumn] >= Date.AddDays(Date.From(DateTime.LocalNow()), -90) &&  "Expiration Date", each if [DateColumn] <= Date.AddDays(Date.From(DateTime.LocalNow()), +90) then Date.AddDays(Date.From(DateTime.LocalNow()), +90) else [DateColumn]) then Date.AddDays(Date.From(DateTime.LocalNow()), +90) else [DateColumn])

so that all the dates after 90 days will fall under else condition