Conditional Column

[Anonymous]

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])

[HotChilli]

DateTime.LocalNow()

and

Date.AddDays()

are the 2 functions you need

[otravers]

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 

[Vijay_A_Verma · Accepted solution]

Replace #date(2022, 7, 28) with

Date.AddDays(Date.From(DateTime.FixedLocalNow()),28)

[Anonymous]

Thanks this worked