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 ...
  • 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