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 M Code
How to bypass the Excel row limit
How can I bypass the Excel row limit of 1,048,576 rows 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 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 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.