From the course: Excel: Power Query (Get & Transform)

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

AddDays to determine the deadline

AddDays to determine the deadline - Microsoft Excel Tutorial

From the course: Excel: Power Query (Get & Transform)

Start my 1-month free trial Buy for my team

AddDays to determine the deadline

“

Power Query has a lot of functions. And here, I'm providing you a link so that you can click and see the functions that are available in Power Query. We'll slide over here. And in this example, I want to show you the Add Days function. Now watch this. In Power Query, if I want to calculate the deadline for Alix and Course 1, Alix gets 90 days from the 28th of March of 2023. I can do this in Excel equals. The 90 plus the date and enter. That would be the deadline. And then we could go to another source and find out if Alix did complete and if Alex completed within the 90 days. Not so easy in Power Query. My cursor is in the dataset. Right-click and get data from Table/Range. My table does have headers. Okay. Now, we got to think about our data types. Right. Our started date has been converted into a date and a time. I'm going to delete this change type step. I'm going to change this to whole number. This needs to be date. This is text. And these names are text. Now, what happens if I…

Contents