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 [Ordfinish] >= #date(2022, 7, 28) then "TBD" else [Ordfinish])
Replace #date(2022, 7, 28) with
Date.AddDays(Date.From(DateTime.FixedLocalNow()),28)
4 Replies
Replace #date(2022, 7, 28) with
Date.AddDays(Date.From(DateTime.FixedLocalNow()),28)
Add 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
DateTime.LocalNow()
and
Date.AddDays()
are the 2 functions you need
