From the course: Excel: Power Query (Get & Transform) (2020)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
AddDays to determine deadline
From the course: Excel: Power Query (Get & Transform) (2020)
AddDays to determine deadline
- [Instructor] Yes, it's possible to write formulas in Power Query. And there are many functions available to us and you can find 'em at this URL that's provided in the Workbook. Let's look at writing a formula in Power Query. All right, we have this data about agents, and we're going back and auditing some licenses because they're in some fishy stuff that we want to investigate. Let's look at Aaro. Took course one, started it the 24th of August 2017, and course A1 is given 90 days to complete in order to remain licensed. Somebody else is going to find the actual completion. What we want to do now is find the deadline and then we'll compare 'em later. All right, let's take this data into Power Query. Click inside the dataset. From Table/Range, OK. We do not want a date time in that Started column, we want a date. Yes, replace that current step. Now we're going to use this funky function. Let's go to Add Column…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.