Forum Discussion
Conditional Column
I am working with a Conditional Column and I want to make the Date Current Date +28 Days instead of hard coded below = Table.AddColumn(#"Filtered Rows", "Custom Order Finish Date", each if [Ordf...
Replace #date(2022, 7, 28) with
Date.AddDays(Date.From(DateTime.FixedLocalNow()),28)
HotChilli
Community Champion
Community ChampionDateTime.LocalNow()
and
Date.AddDays()
are the 2 functions you need