PowerQuery.com and my recorded sessions at MBAS 2019
The Microsoft Business Application Summit was a blast. If you missed it, you can now watch all the Power BI session recordings here, or get a great...
Tag: Power Query
Book update
Are you attending Microsoft Business Applications Summit next week? I hope you can join my session on Power Query and get a chance to win a print version of...
My Sessions at MBAS
June 11-12 are getting near, and it is this time of the year to start getting excited. Microsoft Business Applications Summit is getting close. Do you plan to...
Be a Power Platform Jedi – How to run a book raffle
This is the first blog post in a series of posts that I plan to publish and share some of my demos that I presented during the Power Platform World Tour in...
The Fill Down Hierarchies -Generic Solutions
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...
The Fill Down Hierarchies -Solutions
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...
The Fill Down Hierarchies Challenge
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...
The Impact of Power Query – Survey Results
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...
Preserving context from multiple worksheets – Bonus Exercise – Chapter 5 – #PowerQuery Book
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...
Preserving Context from CSV – Bonus Exercise – Chapter 5 – #PowerQuery Book
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...
