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

OK, if I understand correctly, for Expiration dates that are today through the next 90 days, use today+90 else use current Expiration date. If so, it's:

 

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