Add Number of Days/Weeks/Months to a Date | Power Query in Excel
Вставка
- Опубліковано 17 чер 2021
- If you're new to Power Query, and you want to add a number of days to a date, you might encounter an error message that says "We cannot apply operator + to types Date and Number"
This is a big difference from Excel where you can add the mathematical operators directly to dates.
In this case, Power Query is very specific with its types. There are specific functions you can only use with Numbers, There are specifics functions you can only use with Text. and There are specific functions you can only use with Dates.
For the purposes of this video, we're going to use the
Date.AddDays Function.
We can also use:
Date.AddWeeks
Date.AddMonths
Date.AddYears
to add specific number of weeks/months/years respectively.
I've been looking everywhere for 3 days for this. THANK YOU!
thanks..i was looking for the same..
Great stuff, better explanation as MSFT docs
Great Content, but please improve the audio level of future recordings
thanks this was great help! keep up the good work!
Thanks for this.. kudos!
Thank you very much for this, So thought what if the number of days was constant and no column was created for it, I tried it and it still worked.
Thanks for the great video. What about to use “Date.AddYears" but the column to be used have decimal numbers? PQ indicates error! How can it be resolved?