How to use Date.IsInNextMonth in PowerQuery
The easiest way to dynamically identify dates that are in the following month in Power Query is to use the function Date.IsInNextMonth. We learn how to use the function in this post.
Tag Functions
Tips to move quickly round your Excel spreadsheet
Use Control to move quickly round your Excel spreadsheet When it comes to Excel, every little helps in saving time. A really easy and very effective way to save time and be more efficient is by using keyboard shortcuts and…
How to merge using the Left Anti join in PowerQuery
How can I use the Left Anti join function in PowerQuery? Date.AddDays is a great function that allows us to add days onto a column of Date or DateTime values in the PowerQuery editor. Adding days onto a date value…
How to get data from a PDF into Excel using PowerQuery
How to get data from a PDF into Excel using PowerQuery One of the questions I used to ask all the time as a finance analyst was ‘how can I get data from a PDF and put it into Excel?’…
How to use the TODAY function in Excel
How to use the TODAY function in Excel Date.AddDays is a great function that allows us to add days onto a column of Date or DateTime values in the PowerQuery editor. Adding days onto a date value isn’t something that…
How to use Date.IsInCurrentQuarter in PowerQuery
How to use Date.IsInCurrentQuarter in PowerQuery Date.IsInCurrentQuarter is a useful PowerQuery function that allows us to check whether dates in a column of dates are in the current quarter or not. As Checking whether a date is in the current…
How to use Date.AddDays in PowerQuery
How to use Date.AddDays in PowerQuery Date.AddDays is a great function that allows us to add days onto a column of Date or DateTime values in the PowerQuery editor. Adding days onto a date value isn’t something that you can…
You must be logged in to post a comment.