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 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 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 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.