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...
Author: Gil Raviv
Blogger at https://datachant.com , Ex-Microsoft Senior Program Manager in Excel team, Power Query / Power BI expert, Seasoned Product and Software Engineering Manager.
The new Template Apps in Power BI – Just announced
Last week Microsoft released a preview of the Template Apps - A new experience that was designed for partners and ISVs to deliver streamlined analytics...
The new Template Apps in Power BI
Today Microsoft released a preview of the Template Apps - A new experience that was designed for partners and ISVs to deliver streamlined analytics to...
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...
Power BI Consulting Firms and Their Services – As Seen on AppSource
Are you looking for a Power BI consulting service from one of Microsoft's Gold or Silver partners? You can find such services on the Microsoft AppSource...
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...
Sneak Peek at the book: A PASS BI Webinar
Earlier this week I presented a sneak peek at my book at a PASS BI webinar. You can download the deck here, and watch this video if you missed...
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...
Text Analytics Power BI Template – All In One
In Chapter 12 of my book, I published detailed walkthroughs that cover Translator Text API, Sentiment Analysis, Key Phrase extraction and the detection of...
