In today's blog post, I share the generic solutions for the Fill Down challenge that I posted here. As you recall, we had a table of backlog items with...
In today's blog post, I will share the simple solutions for the problem that I posted here. For the recursion approach, stay tuned for Part 2 of this...
A weekend challenge I hope you are enjoying your second weekend of 2019. I was helping a friend recently figuring out the following data challenge: You...
Recently I shared with you a survey here and asked you to estimate the impact of Power Query: How much time does Power Query save you in a year? How much...
This is the third bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Today's bonus exercise takes...
This is the second bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. In Chapter 5 you learn how to...
Earlier this year I published a survey to assess the impact of Power Query in organizations. I have decided to publish this survey again, and share the results...
This is the first post of a series of bonus exercises that will accompany my book, Collect, Combine, and Transform Data using Power Query in Excel and Power...
This is exciting! The digital version of the book "Collect, Combine and Transform Data Using Power Query in Excel and Power BI" is out. You can purchase it...
Today I got from the production team the first chapters of the book for final proofreading. I had to share with you a screenshot of the first page of Chapter...