Forum Discussion

mdrammeh's avatar
mdrammeh
Helper III
9 years ago

How to Counting Date values Backwards

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

 

Need Help
Show and Tell
Tutorial Requests

2 Replies

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    Probably you mean rows instead of columns.

     

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

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    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