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…
Tag Efficiency
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.