Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Replace #date(2022, 7, 28) with

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

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Replace #date(2022, 7, 28) with

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks this worked