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)
otravers
Community Champion
Community ChampionAdd 28 days to:
Date.From(DateTime.LocalNow())
- https://docs.microsoft.com/en-us/powerquery-m/date-adddays
- https://docs.microsoft.com/en-us/powerquery-m/datetime-localnow