Assign a Date Value which is 30 days prior to Today

[Power007]

Hi Folks,

I'm a newbie needing help from gurus like you.

I need to add a column that assigns a date which is 30 days prior today based on a condition. I tried using Power Query Editor and below is what I have.  It's giving me ERROR for condition 1.

= Table.AddColumn(#"Added Conditional Column", "SystemDate 2", each if [BT Class 2] = "PRIORB" then Date.Day(-30) else [System Date])

I tried using Today() but also didn't work.

Thanks for your help.

[ppm1 · Accepted solution]

You can use this expression to get 30 days ago

Date.AddDays(Date.From(DateTime.LocalNow()), -30)

Pat

[Power007]

Thank you very much. It worked like magic.