How to Counting Date values Backwards

[mdrammeh]

I have a date column titled "Scheduled Start Date" for millions of columns in Power Query. I want to calculate the number of days prior to the "Schedule Start Date".

I tried to formulas for the result always returns an error message:

Date.AddDays([Scheduled Start],-27,MONTH)) 

Could someone help me here at your convenience 🙂

[v-qiuyu-msft]

Hi @mdrammeh,

The syntax of the Date.AddDays() function is Date.AddDays(dateTime, days as number), so you need to modify the expression like this Date.AddDays([Scheduled Start],-27).

As you mentioned you want to calculate the number of days prior to the "Schedule Start Date", I guess the Duration.TotalDays should be more proper, see: DATEDIFF in Power Query.

Best Regards,

Qiuyun Yu

[MarcelBeug]

Probably you mean rows instead of columns.

Anyhow: remove ",MONTH)"  from the formula (or use Date.AddMonths).