Select Page

Phasing Income to Future Dates

Level: Intermediate I do lots of live training, face to face and online, and I always encourage students to bring along any business problems they would like some help with.  Last week I had a great problem that Debbie shared with me that I thought was worth creating...

Inline Table-Valued Functions (TVFs)

Lets start off with what is a table-valued function (TVF)? A TVF is a dynamic table produced at the time of execution, depending on parameters. Like a view, a TVF creates a result set only when it’s executed, but, unlike a view, it can be parameterized. You get two...

#PowerQuery Book Update – Table of Contents

In today’s short post, I would like to share with you the Table of Contents of my book, Collect, Combine and Transform Data Using Power Query in Excel and Power BI. (You can pre-order the book on Amazon here or on Microsoft Press Store here). This post first appeared...